my if formula isnt working

**zazzz** · 02-14-2013, 01:11 AM

Part 1

I would've thought this formula is easy but its not working! Hope someone can advise.

A1 = 50%
A2 = 60%
A3 = 110%

Formula - if(A1>=100% & A2>=100% & A3>=100%, "YES", "NO")

I would expect to get a NO from this, but I'm getting a Yes. Why??

Part 2

in the above range of A1:A3 if there's 1 # >=100% I want the result to say '1', 2 then '2', 3 then '3'. I would do this thru a really long if then else formula but I'm guessing there's a simpler way?

Thanks!
Dan

**FDibbins** · 02-14-2013, 01:14 AM

try this...

if(and(A1>=100%,A2>=100%,A3>=100%), "YES", "NO")

**zazzz** · 02-14-2013, 01:34 AM

awesome that worked! thanks!
i dont get what's wrong w/ putting an & sign tho? i mean i can see its not working but not getting the logic. is it just something that i need to accept or is there a mistake im making here?

also do you knwo the answer to part 2?

**FDibbins** · 02-14-2013, 01:41 AM

Its something you have to accept...its the syntax for an and() statement, thats just the way it works

What are the chances that for instance, the values could be 130% 180% 30%?

**zazzz** · 02-14-2013, 01:45 AM

Originally Posted by FDibbins

Its something you have to accept...its the syntax for an and() statement, thats just the way it works

What are the chances that for instance, the values could be 130% 180% 30%?

im not sure i understand the second part of your question. this was sample data, not actual results, so the chances are whatever you'd want them to be actually. this was the last question in an excel test given to me for a job today.

**FDibbins** · 02-14-2013, 01:52 AM

my reason for asking, was that I thought of changing your formula to something like...
=ROUNDDOWN(SUM(A1:A3),0)

but if the values were something like I suggested, that would not work