Computing.Net > Forums > Windows 2000 > using formulas 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.

using formulas in excel

Reply to Message Icon

Name: aiysha
Date: June 8, 2003 at 10:34:33 Pacific
OS: win98
CPU/Ram: unknown
Comment:

hi!
i have to generate student result in excel. for this i have to calculate grades. when i use the IF function like
IF(column>80%,"A","B"). it displays only two grades. how can i use it to display more grades.



Sponsored Link
Ads by Google

Response Number 1
Name: marc2003
Date: June 8, 2003 at 12:40:55 Pacific
Reply:

use a nested if statement eg

=IF(column>80%,"A",IF(column>70%,"B", IF(column>60%,"C",IF(column>50%,"D","E"))))


0

Response Number 2
Name: aiysha
Date: June 10, 2003 at 09:14:13 Pacific
Reply:

thanx marc2003 it worked out.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







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: using formulas in excel

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

Cleaning Duplicate Entries in Excel 2000 www.computing.net/answers/windows-2000/cleaning-duplicate-entries-in-excel-2000/29014.html

drop down list in excell www.computing.net/answers/windows-2000/drop-down-list-in-excell/31512.html