Forum Discussion
Solved
IF formulas
Can someone help me with how to set up IF when I am trying to calculate no rebate if revenue is $99,000 or less, a 7.5% rebate back to $1 if revenue is between $100,000 and $200,000, then if revenue ...
Let's say you have an amount in A2. The rebate is given by
=SUMPRODUCT((A2>={0,100000,200000,300000})*(A2-{0,0,200000,300000}),{0,0.075,0.025,0.02})
Let's say you have an amount in A2. The rebate is given by
=SUMPRODUCT((A2>={0,100000,200000,300000})*(A2-{0,0,200000,300000}),{0,0.075,0.025,0.02})
