#VALUE if cell blank

[The Animal]

Hi
Why do I keep getting a #VALUE Error when I6 is "". It does have a formula in the cell but no actual value

=IF(OR(I6=""),"",(K6+M6)/I6)/24

Thanks for any help
Stephen

 

[alansidman]

I'm not sure I understand what your formula is trying to achieve. Please explain in simple English what you are trying to accomplish. Then we can probably help.

 

[The Animal]

Thanks for your reply
If I6 is "" (blank) I want my target cell to be blank if not use the formula (K6+M6)/I6)/24
Thanks Alan

 

[jtakw]

Hi,

That's because when I6 is "" Blank, your formula is dividing I6 by 24, thereby causing the #VALUE error.

Also, you don't need the OR function, since you Only have 1 condition, try this version:

=IF(I6="","",(K6+M6)/I6/24)

 

[Scott Huish]

Using only 1 condition in OR is pointless. What you really need to see is if I6 is 0 or not. Your parentheses are also incorrect in your formula (they don't match up). Try this:

=IF(I6,((K6+M6)/I6)/24,"")

 

[The Animal]

Thanks.
So if I6 is blank no matter what the formula that follows the target cell will always be blank and ignore the formula?

 

[jtakw]

Yes.

 

[The Animal]

Further to above.
So I have used the above (IF(I6="","",(K6+M6)/I6/24) and works fine then rewritten to apply as per below and same #value error occurs in new target cell?
=IF(I5="","",($L5+J5)/$I5)/1440

 

[alansidman]

You need to move the closing parens to the right of 1440. Currently, if you have a blank, then you are dividing the blank by 1440 and getting the Error message.

 

[jtakw]

Further to above.
So I have used the above (IF(I6="","",(K6+M6)/I6/24) and works fine then rewritten to apply as per below and same #value error occurs in new target cell?
=IF(I5="","",($L5+J5)/$I5)/1440

You're doing the Exact same thing as your other formula here, when I5 is Blank, you're dividing it by 1440

Do this:

=IF(I5="","",($L5+J5)/$I5/1440)