# If Condition in Excel

October 12, 2005 at 03:52:25
Specs: Win 2000, P4

 Dear FriendsI'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

See More: If Condition in Excel

#1
October 12, 2005 at 07:52:58

 Hi PeterTry This=IF(A1>A2,IF(A1>A3,A1,IF(A2>A3,A2,A3)),IF(A2>A3,A2,A3))

Report •

#2
October 12, 2005 at 08:19:43

 Thanks! dtech10You'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.

Report •

#3
October 13, 2005 at 02:48:53

 Hi FriendsI 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 = D2) N & N = N3) F & F = F4) 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

Report •

Related Solutions

#4
October 13, 2005 at 04:11:03

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

Report •

#5
October 13, 2005 at 04:46:18

 Thanks! robtaylorYou guys are really wonderful. I never knew the conditions could be set in such a way.Best regards

Report •

#6
October 27, 2005 at 10:15:10

 gk

Report •

#7
October 27, 2005 at 10:16:01

 Hi,I have set of marks out of 100. Like5,8,11,26,38,59,47,59,85,29,92 etc.I wanted to multiply all the marks by 2if they are less than 20, multiply by 3if between 20 and 40, multiply by 4 ifbetween 40 and 70 and multiply by 5 if greater than 70. I tried using if statementbut no luck. Does there any solution.Thanks in advance.gk

Report •