| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with nested function
Help please.
I have cell C2 as an option of either less then 1400cc, more than 2000cc or a number in between. I have cell D2 as 'Petrol' or 'Diesel'. I have cell K2 as a mileage number (ie: 10). Under certain conditions, I need to calculate the pence per mile for a given mileage. This is the function I have compiled: =IF(C2<=1400,K2*0.09,IF(D2="Petrol",K2*0.11,IF(C2< =2000,K2*0.09,IF(C22000,IF(D2="Diesel",K2*0.12,K2 *0.16))))) This function returns all correct answers unless I select petrol, with more than 2000cc. It will not return K2*0.16 which is what I am after? I have tried many times but I am stuck. Please can anyone help with completing this nested function, or is there another way of solving my requirements? Many thanks, Colin. -- Q3PD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested Function | Excel Discussion (Misc queries) | |||
| can you nested sum and round function within if function? | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Nested Function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
