| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF functions
Try this
=IF(A1<L1,A1,IF(AND(A1K1,A1<K2),L1+0.9*(A1-L1),IF(AND(A1K2,A1<K3),L1+0.9*L2+0.84*(A1-L1-L2),IF(A1K3,L1+0.9*L2+0.84*L3+0.79*(A1-L1-L2-L3))))) -- HTH, Barb Reinhardt "LTHAM" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF functions
THANK YOU, BARB....THAT IS EXACTLY WHAT I NEEDED!! I'M GRATEFUL!!
"Barb Reinhardt" wrote: Try this =IF(A1<L1,A1,IF(AND(A1K1,A1<K2),L1+0.9*(A1-L1),IF(AND(A1K2,A1<K3),L1+0.9*L2+0.84*(A1-L1-L2),IF(A1K3,L1+0.9*L2+0.84*L3+0.79*(A1-L1-L2-L3))))) -- HTH, Barb Reinhardt "LTHAM" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
