| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if and conditional formulas
I need a conditional formula for a commission worksheet that drives one
commission payout based on the first argument, another payout based on the 2nd argument and $0 otherwise. Is there a way to get more than just one value if True, just one value if False limitation? =IF(AND(M11<100%,M11=98%),D16,IF(M11=100%,D17),i f(M11<98%,0))) -- News Gal |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if and conditional formulas
=LOOKUP(M11,{0,0.98,1},{0,"A","B"})
"Newsgal" wrote: I need a conditional formula for a commission worksheet that drives one commission payout based on the first argument, another payout based on the 2nd argument and $0 otherwise. Is there a way to get more than just one value if True, just one value if False limitation? =IF(AND(M11<100%,M11=98%),D16,IF(M11=100%,D17),i f(M11<98%,0))) -- News Gal |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if and conditional formulas
That worked! Thank you!!!
-- News Gal "Teethless mama" wrote: =LOOKUP(M11,{0,0.98,1},{0,"A","B"}) "Newsgal" wrote: I need a conditional formula for a commission worksheet that drives one commission payout based on the first argument, another payout based on the 2nd argument and $0 otherwise. Is there a way to get more than just one value if True, just one value if False limitation? =IF(AND(M11<100%,M11=98%),D16,IF(M11=100%,D17),i f(M11<98%,0))) -- News Gal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formulas | New Users to Excel | |||
| Conditional Formulas | Excel Worksheet Functions | |||
| Conditional Formulas Maybe? | Excel Discussion (Misc queries) | |||
| How do I set up conditional formulas | Excel Worksheet Functions | |||
| conditional formulas | Excel Worksheet Functions | |||
Linear Mode
