Excel "IF" functions

[Katrina]

Hello,
I am trying to create an "IF" formula to indicate an "X" in a cell if the
following criteria is met:

10% of entity's Total Assets(C11) and .05% total variance (between two
periods) and any variances over $500K

Thanks!

 

[Fred Smith]

An example would have helped a lot.

What do we compare 10% of total assets to?
How do you calculate variance?
Do you meant .05% variance, or 5% variance?
When you say 500K, do you mean 500000?
When you say "and" do you mean *all* criteria must be met, or any one of
them?

Regards,
Fred

 

[joel]

You nee to use an OR function inside the IF

=if(OR(Condition 1, Condition 2, condition 3, condition 4),true,false)


I'm not sure exactly what you want but it would be something like thi
with the two number being in cells B11 and C11

=if(OR(abs(C11-B11) > (.1 * C11), B11/C11 < .95, B11/C11 > 1.05
abs(B11-C11) > 500,000,"X","")