View Single Post
  #1   Report Post  
Bootface Bootface is offline
Junior Member
 
Posts: 11
Cool Keeping cells blank even though formula is input

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