Quote:
Originally Posted by Bootface
I have the following formula in my work sheet in cell U1237
=IF(K1237=2,(U1236+1.3),IF(K1237<=1,U1236+1)) however when I drag this formula down it calculates blank cells as a 0 and returns a figure. How do I keep the below cells blank whilst keeping the formula. When I try the Isblank method I just get an error saying too many arguments. Thanks
|
How about
:
=IF(K1237="","",IF(K1237=2,(U1236+1.3),IF(K1237<= 1,U1236+1)))
Does that do what you're after?