=IF(ISBLANK(C28),"Choose ONE",C28)
drag the Fill handle to copy


"Rich" wrote:

I am trying to write a formula that will allow automatically run a
calculation from the occupied cell over the empty ones. The idea is if the
payment is by the month, you would use this cell and formula, if quarterly,
then use this cell and formula, and if yearly use this cell and formula.
=IF(ISBLANK(C28),"Choose ONE",(C28/1)) will work for the first cell. How do
I get the other two?

Thanks