| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Formula in Excel
I need to use 11 IF sections to calculate grades....ie:
=IF(D297,"4",IF(D295,"3.7",IF(D293,"3.5",IF(D2 90,"3",IF(D287,"2.7".....etc,etc What can I do????? This was just thrown in my lap this morning and I need it ASAP. Please help.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Formula in Excel
Use a VLOOKUP table or CHOOSE. Look in the help index for both
-- Don Guillett Microsoft MVP Excel SalesAid Software "Cindy" wrote in message ... I need to use 11 IF sections to calculate grades....ie: =IF(D297,"4",IF(D295,"3.7",IF(D293,"3.5",IF(D2 90,"3",IF(D287,"2.7".....etc,etc What can I do????? This was just thrown in my lap this morning and I need it ASAP. Please help.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Formula in Excel
Hi Cindy
create a table, column A 97,95 etc Column B 4,3.7,3 Then in E2 enter the formula as follos =SUMPRODUCT(--(A1:A15=D2),B1:B15) "Cindy" wrote: I need to use 11 IF sections to calculate grades....ie: =IF(D297,"4",IF(D295,"3.7",IF(D293,"3.5",IF(D2 90,"3",IF(D287,"2.7".....etc,etc What can I do????? This was just thrown in my lap this morning and I need it ASAP. Please help.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Linear Mode
