IF Funtion

[brett4098]

How would I formulate "if (cell) has a number, then do this.
IF(C1=any number, then do this, else do this)?

 

[Todd Bardoni]

=IF(C1, "It's a number", "It's not a number")

OR, if the cell can also contain TEXT other than just being blank, then:

=IF(ISNUMBER(C1), "It's a number", "It's not a number")

 

[Aladin Akyurek]

=IF(C1, "It's a number", "It's not a number")

Todd,

The idiom "IF(C1" holds when what we deal with is a number (either zero or non-zero).

If the 'numberness' is the issue, we need either...

=IF(ISNUMBER(C1), X, Y)

or

=IF(N(C1), X, Y)

The last one is less generic, that is, it only distinguishes between text and number on the one hand and zero and non-zero on the other hand.

 

[Todd Bardoni]

Yep, I realized that after my original post and made the edit.

Thanks!