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

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!

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

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!

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

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 -

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

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

Regards,

Alan



"HowlingBlue" wrote in message
...
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!