View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich Rich is offline
external usenet poster
 
Posts: 298
Default Selecting occupied cell over empty ones

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