Selecting occupied cell over empty ones
 

=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

Selecting occupied cell over empty ones
 

Try this in say F28:
=IF(AND(C28="",D28="",E28<""),E28/12,IF(AND(C28="",D28<"",E28=""),D28/3,IF(AND(C28<"",D28="",E28=""),C28,"Input
only one value in either C28, D28 or E28. In C28 for monthly payments, in D28
for quarterly payments, in E28 for annual payments")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rich" wrote:
Ok maybe better description is needed... If I enter 100 in cell C28 then the
formula C28/1 will perform(Answer 100). If I enter a number, say 300, in D28
then D28/3 will perform(Answer 100) or if I enter a number, say 1000, in E28
then E28/12 will perform (answer 83.333)