| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to create a two part formula
Something like:
=IF(C4=0,0,H70.9,4,IF(H7=0.8,3,IF(H7=0.7,2,IF(H 7=0.6,1,0))))) Regards, Fred "DMW" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to create a two part formula
=If(C4 = 0, 0, IF(H70.9,4,IF(H7=0.8,3,IF(H7=0.7,2,IF(H7=0.6,1 ,0)))))
-- HTH... Jim Thomlinson "DMW" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to create a two part formula
Hi,
=if(C4=0,0,IF(H70.9,4,IF(H7=0.8,3,IF(H7=0.7,2,I F(H7=0.6,1,0))))) "DMW" wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to create a two part formula
Let's say goodbye to IF for this one
First try =LOOKUP(H7*10,{0,6,7,8,9},{0,1,2,3,4})*(C4<0) But that throws up a 4 for H7 =0.9 and you have H70.9 How about =LOOKUP(H7*10,{0,6,7,8,9.0000001},{0,1,2,3,4})*(C4 <0) or =(C4<0)*((H7=0.6)+(H7=0.7)+(H7=0.8)+(H70.9)) best wishes -- Bernard Liengme Microsoft Excel MVP people.stfx.ca/bliengme email address: remove uppercase characters "DMW" wrote in message ... 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! |
| Reply |
| 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)
Linear Mode
