| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
2 If Statements between 2 values Q
I am trying to write 2 IF Statements and am having problems
1) If C11 is between .85 & .99 then Return Rates!G14 2) If C11 is greater than .99 then Return Rates!C14 I thought it was this =(IF(C11=0.85,Rates!G14)*OR(IF(Starters!C11<=0.99 ,Rates!G14)))*(IF(C11.99, Rates!C14)) But its not coming up with my expected result |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Save External Link Values | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| Linked values turn to #REF! after clicking don't update | Excel Worksheet Functions | |||
Threaded Mode
