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 |
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 |
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 |
All times are GMT +1. The time now is 03:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com