Formula question - isblank, sums?

EAP

Trying to figure out how to make this work. I'm terrible with advanced formulas like what I'm trying to accomplish, and have no idea how to make it work.

The extension rate needs to be multiplied by 12, then divided by 13 to give the cost per period (13 periods of four weeks, versus 12 months). Then I would apply/drag this formula down the entire column so they all work the same.

However, not everything is on an extension. perhaps it seems trivial, but I do not want it to output anything in the POP column if there's no value in the extension rate. It would be easier to see if it remained blank.

Jeremy_D

Use an =ISBLANK() formula. So for example would be:

=IF(ISBLANK([Extension Rate]@row), "", [Extension Rate]@row * 12/13)

This says that if the extension rate is blank then leave the cell blank but if not then *12/13. Then right click and column formula to convert it into a formula for the whole column.

Hope that answers the question!

Paul Newcome

I would use this:

=IF([Extension Rate]@row <> "", [Extension Rate]@row*12/13)