If/and

**tuneddown** · 10-21-2009, 10:18 PM

I'm trying to use multiple if and and statements in excel. However, every time I try to do this, I get an error message. I'm just not sure what I'm doing wrong so I figured I'd ask. Basically, I want excel to recognize the highest of 3 numbers (they are NPV values) and make a recommendation on what to do based on which one is the largest number. So:

If cell D11>D20 and D11>D30 then I want it to say "rent machine".
If cell D20>D11 and D20>D30 then I want it to say "purchase current machine"
If cell D30>D11 and D30>D20 then I want it to say "purchase newer machine"

The way that I tried doing this was a series of IF and AND statements but it isn't working out. If anyone could help me figure out how to formulate this I'd really appreciate it.

**teylyn** · 10-21-2009, 10:21 PM

hmm.... without a spreadsheet before me, I'd say

=IF(AND(D11>D20,D11>D30),"rent machine",IF(AND(D20>D11,D20>D30),"purchase current machine",IF(AND(D30>D11,D30>D20),"purchase newer machine","can't decide")))