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.
|