On 24/07/2012 6:54 PM, Bootface wrote:
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




Hi

=IF(K1237="","",IF(K1237=2,(U1236+1.3),IF(K1237<= 1,U1236+1)))

HTH
Mick.