From: Ron Rosenfeld on 31 Mar 2010 15:47 On Wed, 31 Mar 2010 12:10:07 -0700, MelissaS wrote: >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! > Your syntax is the same as: (D5 or < F5, I only care about the relationships between D5 and E5 and then E5 and F5, so it looks like your original suggestion will work. But your comment about my intent helped me think through it a little bit more. Thanks! "Joe User" wrote: > "MelissaS" wrote: > > Can anyone tell me why this IF formula isn't working? > > =IF(D5E5>F5,"B", > > IF(D5F5,"C",IF(D5>E5 > =IF(AND(D5 IF(AND(D5>E5,E5>F5),"B", > IF(AND(E5>D5,E5>F5),"C", > IF(AND(E5 > Note that that returns "F" when E5=D5 or E5=F5. So if D5 "F" instead of "A". Is that what you really want? > > Also, when you write D5F5, do you intend to imply D5>F5? As I wrote it, > the formula returns "C" for both D5 > A similar arises with D5>E5 > If you resolve these issues differently, it is very likely that your formula > can be simplified. > > > ----- original message ----- > > "MelissaS" wrote: > > > 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! > > > > First  |  Prev  |  Pages: 1 2 Prev: Looking a value up for aNext: Unique filtering to another sheet ?