Excel "IF" functions
in [Functions]
|
Prev: Locating values in a range and bringing up the corresponding p
Next: Extracting the latest info from 1st sheet and placing into a2nd s
From: Katrina on 22 Feb 2010 15:09 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!
From: Fred Smith on 22 Feb 2010 18:45 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 "Katrina" <Katrina(a)discussions.microsoft.com> wrote in message news:E849C382-807A-4544-8A1B-BB186F5DFC2C(a)microsoft.com... > 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!
From: joel on 22 Feb 2010 18:50
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 this 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","") -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=181548 [url="http://www.thecodecage.com"]Microsoft Office Help[/url] |