Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |