Nested if statements - is there a better way?
=VLOOKUP(A1,{0,0.01;1000001,0.02;1700001,0.03;1800 001,0.04;1900001,0.05;2000
001,0.06},2)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"masterbaker" wrote in message
...
Here's the deal:
Think of this as a royalties issue. Depending on the sales for a specific
month, the percentage of royalties due will change. Say January sales were
$1,850,00 (A1). Then the royalties would be 3%:
Sales less than: Royalty %:
$1,000,000 1%
$1,700,000 2%
$1,800,000 3%
$1,900,000 4%
$2,000,000 5%
....and so on
I am tired of nesting my if statments and am wondering if there is some
other formula or something that would work? (if(A1<=2Mill, 5%,
if(A1<1.9Mill,
4%.......))
Please help me unnest my if statements!
|