if formula

[jamied2000]

I have a cell (A24) that has a data validation list. In aother cell (A27) i can enter a differnt number than whats cell (A24). So in a third cell (D24) I want it to select a certain cell(AA36 or AA37) depending on what is entered in either cell A24 or A27. I have tried =if(A24="other",if(A27<150,AA36,AA37,if(A24<150,AA36,AA37)). I think i have the formula correct but it does not work out correct. Any ideas on how to fix it?

[Sam Capricci]

this part...=if(A24="other", should be telling the formula what to do if it finds that, then the next part... if(A27<150,AA36,AA37,if(A24<150,AA36,AA37)). seems to be a repeat of the same instructions.
Seems something like this...
=if(A24="other","do this",if(OR(A27<150,A24<150,AA36,AA37)).
Haven't tested it but that seems like it is closer. W/o data to test against I'm just guessing.