mamcelr
Thread Starter
 Joined
 Oct 24, 2011
 Messages
 39
I have a nested "IF" statement that inlcudes the "OR" function because I have more than 7 logical tests. One of the logical tests looks for two fields to be true in order to return the "value if true". If either or both fields are false, then the "value if false" is returned, in this case zero. When the value of the first field is correct, but the value of the second field is not correct, zero is returned, which is the "value if false" and a correct return.
However, when both fields are false, the formula is returning the word "FALSE" instead of zero.
The attached file shows these returns and the formulas. Cells F27 are corrrect returns (highlighted in green), while cells F811 are not correct returns (highlighted in red).
Any ideas on how to return the "value if false" (zero) in cells F811 would be appreciated.
However, when both fields are false, the formula is returning the word "FALSE" instead of zero.
The attached file shows these returns and the formulas. Cells F27 are corrrect returns (highlighted in green), while cells F811 are not correct returns (highlighted in red).
Any ideas on how to return the "value if false" (zero) in cells F811 would be appreciated.
Attachments

50.7 KB Views: 140