Posted to microsoft.public.excel.worksheet.functions

elaine

Posts: n/a

logic (IF) functions

I have the following function that I am using to replace letter grades with
grade points. Excel will not allow me to enter more than seven nested
functions. Is there another way?
=IF(D3="a","4",IF(D3="b+","3.5",
IF(D3="b","3",IF(D3="c+","2.5",IF(D3="C","2",IF(D3 ="D+","1.5",IF(D3="D","1",IF(D3="F","0"))))))))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User-defined functions created in Excel 2000 fail in Excel 2003	goodguy	Excel Discussion (Misc queries)	1	October 3rd 05 07:04 PM
Visible rows and functions that work	tracy	Excel Worksheet Functions	2	August 19th 05 05:25 AM
Logic question	ACDenver	Excel Discussion (Misc queries)	1	August 16th 05 04:29 AM
AVERAGE and STDEV functions with logic	t-rung	Excel Worksheet Functions	1	May 26th 05 07:11 PM
Need help setting up a formula using perhaps the logic functions .	drlisa0318	Excel Worksheet Functions	1	February 11th 05 10:17 PM

All times are GMT +1. The time now is 02:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us