Another IF statement needed
 

In M5 I need to add to the existing formula of =$L$1-G5 this: If there is
any number at all in N5, then M5 will be blank, otherwise it will calculate
$L$1-G5.

Another IF statement needed
 

=if(isnumber(N5),"",$L$1-G5)
--
ChrisJ
Omaha


"Connie Martin" wrote:

In M5 I need to add to the existing formula of =$L$1-G5 this: If there is
any number at all in N5, then M5 will be blank, otherwise it will calculate
$L$1-G5.

Another IF statement needed
 

Try...

=IF(ISNUMBER(N5),"",$L$1-G5)

Hope this helps!

In article ,
Connie Martin wrote:

In M5 I need to add to the existing formula of =$L$1-G5 this: If there is
any number at all in N5, then M5 will be blank, otherwise it will calculate
$L$1-G5.

Another IF statement needed
 

=IF(ISNUMBER(N5),"",$L$1-G5)
--
David Biddulph

"Connie Martin" wrote in message
...
In M5 I need to add to the existing formula of =$L$1-G5 this: If there is
any number at all in N5, then M5 will be blank, otherwise it will
calculate
$L$1-G5.

Another IF statement needed
 

Thank you! Thank you! Thank you! You all know your stuff! You all came up
with the same answer!

"Connie Martin" wrote:

In M5 I need to add to the existing formula of =$L$1-G5 this: If there is
any number at all in N5, then M5 will be blank, otherwise it will calculate
$L$1-G5.