| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to create a two part formula
The formula below will return a GPA for our salespeople
=IF(H70.9,4,IF(H7=0.8,3,IF(H7=0.7,2,IF(H7=0.6, 1,0)))), but I need to add one more criteria and that if another cell (C4) = 0 then the results of this formula need to be 0 as well. I hope this makes sense, can someone please help me. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a hyperlink to open a file with part of the name | Excel Worksheet Functions | |||
| Create a Hyperlink as part of a macro | New Users to Excel | |||
| How do I create a formula using part of the data in 1 cell? | Excel Worksheet Functions | |||
| Can I create an IF statement that looks for part of a string of te | Excel Worksheet Functions | |||
| how do I create a line graph for part of the periods? | Charts and Charting in Excel | |||
![DMW[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
