MrExcel.com - Your One Stop for Excel Tips & Solutions

IF statement trouble

Posted by Al on December 24, 2001 8:49 AM

I am having trouble with the if statement below, for some reason I cannot get it to work. I have tried several varations but to no avail. need help.

=IF(AM47BU29<BV29,"good",IF(AM47>BV29<BW29,"average",IF(AM47>BW29<BX29,">average","excessive"))))

Posted by Adam S. on December 24, 2001 8:57 AM

try this


basically, turn sections like (am47>bu29<bv29) into AND(am47>bu29,bu29<bv29)=true

eg.

=if(AM47bu29,bu29<bv29)=true,"good",if(AND(am47>Bv29,Bv29<Bw29)=true,"average",If(AND(am47>bw29,bw29<bx29)=true,">average","excessive"))))

good luck,
Adam S.

Posted by Adam S. on December 24, 2001 8:58 AM

try this


basically, turn sections like (am47>bu29<bv29) into AND(am47>bu29,bu29<bv29)=true

eg.

'=if(AM47bu29,bu29<bv29)=true,"good",if(AND(am47>Bv29,Bv29<Bw29)=true,"average",If(AND(am47>bw29,bw29<bx29)=true,">average","excessive"))))

good luck,
Adam S.

Posted by Adam S. on December 24, 2001 8:59 AM

try this


basically, turn sections like (am47>bu29<bv29) into AND(am47>bu29,bu29<bv29)=true

eg.

'=if(AM47bu29,bu29<bv29)=true,"good",if(AND(am47>Bv29,Bv29<Bw29)=true,"average",If(AND(am47>bw29,bw29<bx29)=true,">average","excessive"))))

good luck,
Adam S.