Dear Friends I'm trying to use the "If" condition to pick the highest integer among 3 sets of integer e.g. 2,3,1 by using =IF(A1>A2,A1,IF(A1>A3,A1,IF(A3>A2,A3,A2))) but is unable to get the right answer consistantly.

Would appreciate your help on this. Thank you

Hi Peter Try This

=IF(A1>A2,IF(A1>A3,A1,IF(A2>A3,A2,A3)),IF(A2>A3,A2,A3))

Thanks! dtech10 You're GREAT! I spent hours trying to figure out where I had gone wrong and voila! you solved it in a jiffy!

Thanks again pal.

Hi Friends I have another seemingly simple condition but I just couldn't get it right. Would appreciate if you could enlighten me.

I'm have four sets of conditions:

1) N & F = D

2) N & N = N

3) F & F = F

4) F & N = NI tried using the following but some came out as "False":

IF(A="N",IF(B="F","D"),IF(A="N",IF(B="N","N"),IF(A="F",IF(B="F","F"),IF(A="F",IF(B="N","N"))))

Thanks

Here you go: =IF(A1&B1="NF","D",IF(A1&B1="NN","N",IF(A1&B1="FF","F","N")))

Thanks! robtaylor You guys are really wonderful. I never knew the conditions could be set in such a way.

Best regards

gk

Hi,

I have set of marks out of 100. Like

5,8,11,26,38,59,47,59,85,29,92 etc.

I wanted to multiply all the marks by 2

if they are less than 20, multiply by 3

if between 20 and 40, multiply by 4 if

between 40 and 70 and multiply by 5 if

greater than 70. I tried using if statement

but no luck. Does there any solution.

Thanks in advance.gk

Ask Your Question

Weekly Poll

Do you believe Microsoft when it says it views the "Desktop" as the core of Windows?

Discuss in The Lounge

Poll History