Error showing up as #VALUE! in if function

[vijay]

Hi,

I have given Function =IF(G93>1,G93+14,IF(G93<1," ")) in Column G,H,I & J
what happen is, if the date is there in the column F then everything is ok,
(As all the Column G,H,I & J are related to each other whereas the column G
is related to column F)
but the problem is when the date is not in Column F then the Column H,I & J
shows up and error as #VALUE!.
What I want is even if the date is not there in column F the Column H,I & J
should not show up the error #VALUE
Please help

 

[JoeU2004]

What I want is even if the date is not there in
column F the Column H,I & J should not show
up the error #VALUE

Well, I don't see any reference to column F in your formula, and the comment
"As all the Column G,H,I & J are related to each other whereas the column G
is related to column F" does not help to clarify this.

But making an assumption, perhaps the following paradigm will help:

=IF(F93="", "", IF(F93>1,F93+14, IF(F93<1,"")))

Note: I replace " " with "" (no space) in the last term. It is poor form
to use " " (with space); it will likely screw up other formulas that attempt
to recognize a "blank" cell.

But your original logic is flawed: it fails to take care of the case when
F93 (G93) is zero, resulting in FALSE :-(. And I wonder if the conditional
expression F93<1 is a kludge that you intended to take care of the case when
"the date is not there".

So perhaps one of the following is a better solution:

=IF(F93="", "", F93+14)

=IF(F93="", "", IF(F93>1, F93+14, ""))


----- original message -----