Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF functions
I need help with the following:
If cell A1 is < L1, then the answer is cell A1, but If cell A1 is K1 but < K2, then the answer is 100% of L1 plus 90% of (cell A1-L1), but If cell A1 is K2 but < K3, then the answer is 100% of L1 plus 90% of L2 plus 84% of (Cell A1-L1-L2), but If cell A1 is K3, then the answer is 100% of L1 plus 90% of L2 plus 84% of L3 plus 79% of (Cell A1-L1-L2-L3) Cell A1 is the variable K1=2400 L1=2400 K2=4000 L2=1600 k3=7143 L3=3143 How do I do this? I'm supposing I use nested IF functions, but I cannot get it to work. I need this late tonight if at ALL possible. Thanks so much! Lisa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
XL2003 FILTER FUNCTIONS VS. XL2007 FILTER FUNCTIONS | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |