From: MelissaS on 31 Mar 2010 15:10 Can anyone tell me why this IF formula isn't working? =IF(D5E5>F5,"B", IF(D5F5,"C",IF(D5>E5 Can anyone tell me why this IF formula isn't working? > > =IF(D5E5>F5,"B", > IF(D5F5,"C",IF(D5>E5 > It's returning "B" every time. D5, E5, and F5 are all derived from > formulas. Is that the problem? I appreciate any help! > > You can't use multiple comparisons that way. Try it like this: =IF(AND(D5E5,E5>F5),"B", IF(AND(D5F5),"C", IF(AND(D5>E5,E5 wrote in message news:D8FB3409-635F-40C9-A745-004450258182(a)microsoft.com...> Can anyone tell me why this IF formula isn't working? > > =IF(D5E5>F5,"B", > IF(D5F5,"C",IF(D5>E5 > It's returning "B" every time. D5, E5, and F5 are all derived from > formulas. Is that the problem? I appreciate any help! > > From: tompl on 31 Mar 2010 15:31 You cannot chain equations together. For example, D5 Can anyone tell me why this IF formula isn't working? > > =IF(D5E5>F5,"B", > IF(D5F5,"C",IF(D5>E5 > It's returning "B" every time. D5, E5, and F5 are all derived from > formulas. Is that the problem? I appreciate any help! > > From: Joe User on 31 Mar 2010 15:44 "MelissaS" wrote:> Can anyone tell me why this IF formula isn't working? > =IF(D5E5>F5,"B", > IF(D5F5,"C",IF(D5>E5E5,E5>F5),"B", IF(AND(E5>D5,E5>F5),"C", IF(AND(E5F5, do you intend to imply D5>F5? As I wrote it, the formula returns "C" for both D5E5 Can anyone tell me why this IF formula isn't working? > > =IF(D5E5>F5,"B", > IF(D5F5,"C",IF(D5>E5 > It's returning "B" every time. D5, E5, and F5 are all derived from > formulas. Is that the problem? I appreciate any help! > >  |  Next  |  Last Pages: 1 2 Prev: Looking a value up for aNext: Unique filtering to another sheet ?