View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Bootface View Post
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?