Nested IF's with Logical Arguments - Doing something wrong her
 

Thanks Dave, but I must still be doing something wrong. Here's the statement
I used, patterned after yours below but using the apprpriate cell references
from my spreadsheet. Excel says that the formula refers to itself, creating
a circular reference. My guess is that I have a syntax error between the two
repeating mathmatical arguments:

=IF(AND($F$28=100,E180,F180,G18=E18*F18*1000/$E$7),E18*F18*1000/$E$7,"")

All help is appreciated...

"Dave F" wrote:

Use AND:

=IF(AND(F28=100,E130,F130,I13=E13*E14*1000/E7),E13*E14*1000/E7,[else what]

See my response to your other post. With this question, you don't specify
what you want returned if the critieria are NOT matched (this is the [else
what] portion above. This could be as simple as returning a blank, "" , or
it could be a text message, or another logic test.

Dave
--
Brevity is the soul of wit.


"ConfusedNHouston" wrote:

Similar to a post of a few minutes ago but actually a different problem:

Here's the formula:

=IF($F$28=100,IF(E130,IF(F130,I13=E13*E14*1000/$E$7,"")))

I'd like it to throw the value of the expression E13*E14*1000/$E$7 into the
cell if all three conditions are met. Even when all 3 conditions are met, I
get a cell value of FALSE. Is it syntax or am I missing something else.