Articles

If Condition in Excel

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

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



See More: If Condition in Excel

Report •


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

Hi Peter

Try 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! 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.


Report •

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

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 = N

I 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! robtaylor

You 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. 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


Report •


Ask Question