Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Windows 2000 > If Condition in Excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

If Condition in Excel

Reply to Message Icon

Name: Peter Wong
Date: October 12, 2005 at 03:52:25 Pacific
OS: Win 2000
CPU/Ram: P4
Comment:

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




Sponsored Link
Ads by Google

Response Number 1
Name: dtech10
Date: October 12, 2005 at 07:52:58 Pacific
Reply:

Hi Peter

Try This

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


0

Response Number 2
Name: Peter Wong
Date: October 12, 2005 at 08:19:43 Pacific
Reply:

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.


0

Response Number 3
Name: Peter Wong
Date: October 13, 2005 at 02:48:53 Pacific
Reply:

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



0

Response Number 4
Name: robdtaylor
Date: October 13, 2005 at 04:11:03 Pacific
Reply:

Here you go:

=IF(A1&B1="NF","D",IF(A1&B1="NN","N",IF(A1&B1="FF","F","N")))


0

Response Number 5
Name: Peter Wong
Date: October 13, 2005 at 04:46:18 Pacific
Reply:

Thanks! robtaylor

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

Best regards


0

Related Posts

See More



Response Number 6
Name: pre2grk
Date: October 27, 2005 at 10:15:10 Pacific
Reply:

gk


0

Response Number 7
Name: pre2grk
Date: October 27, 2005 at 10:16:01 Pacific
Reply:

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


0

Sponsored Link
Ads by Google
Reply to Message Icon



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows 2000 Forum Home


Sponsored links
Ads by Google


Results for: If Condition in Excel
If loop in excel www.computing.net/answers/windows-2000/if-loop-in-excel/65643.html

Macro Problems in Excel www.computing.net/answers/windows-2000/macro-problems-in-excel/40099.html

formulas in excel 2000 www.computing.net/answers/windows-2000/formulas-in-excel-2000/24956.html