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
