You could have used ISNUMBER( ).

Pete

On Mar 16, 7:36 pm, HowlingBlue wrote:
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.



"HowlingBlue" wrote:
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!- Hide quoted text -

- Show quoted text -