Keeping cells blank even though formula is input

B

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 thi
formula down it calculates blank cells as a 0 and returns a figure. Ho
do I keep the below cells blank whilst keeping the formula. When I tr
the Isblank method I just get an error saying too many arguments. Thank
 
V

Vacuum Sealed

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

Spencer101

Bootface;1603930 said:
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 thi
formula down it calculates blank cells as a 0 and returns a figure. Ho
do I keep the below cells blank whilst keeping the formula. When I tr
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
 
J

joeu2004

Bootface said:
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.

I presume K1237 is never between 1 and 2, e.g. 1.5. Otherwise, your formula
would be flawed to start with. So you might write:

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

No need to test K1237<=1. That is implied when K1237>=2 is false.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top