formula help: IF a cell has any number in it.....

[Guest]

I basically want to have a formula in a cell that will perform one
calculation if a certain cell is empty, but if that cell has a number in it,
will perform a calculation on that cell. Anyone know how to do this?

My idea was =IF(D5=(character for "any number"),D5+B3,C5+B3)

Anyone have ideas on this? Thank you for any help!

 

[Guest]

nvm, fixed it myself. Used ISBLANK, so that if the cell was empty, then it
would do one calculation, if cell was not, it would do second calculation.

 

[Pete_UK]

You could have used ISNUMBER( ).

Pete

nvm, fixed it myself. Used ISBLANK, so that if the cell was empty, then it
would do one calculation, if cell was not, it would do second calculation.







- Show quoted text -

 

[Alan]

=IF(ISBLANK(D5),C5+B3,D5+B3)

Regards,

Alan