If And Or formula problem! Just cant work it out!!

[Wilgoss]

Hi - please see the attached

I need a return in a cell which gives me a result based on results elsewhere

Attached has the explanation

Thanks for any help as usual

PaulForum Potential.xlsx

[ericdudkowski]

I Tested this, it should work. Use the formula:

=IF(G9=1,"No Potential",IF(AND(G9>1,G9<=2),"Potential with Development",IF(AND(G9>2,G9<=3),"Future Potential",IF(AND(G9>3,G9<=4),"Immediate Potential",IF(G9>4,"High Potential","")))))

Eric

[Ace_XL]

Shorter

Please Login or Register  to view this content.

[Steve N.]

Short and clean...

=LOOKUP(G9,{1,2,3,4},{"No Potential","Future Potential","Immediate Potential","High Potential"})

[Wilgoss]

Brilliant! Thanks as usual!

Paul