Help with nested formula
Set up this table somewhere on your sheet (eg X1:Y5):
1 30%
10001 27%
20001 24%
30001 21%
40001 18%
Then, assuming your value of 20450 is in A1, use this formula to
return the appropriate percentage:
=IF(A1<1,0,VLOOKUP(A1,X1:Y5,2))
Hope this helps.
Pete
On May 16, 1:08 am, Rykar2 wrote:
Hi,
Could you please help me with a formula for the following situation:
I have the amount of 20450.
(1-10000) at 30%
(10001-20000) at 27%
(20001-30000) at 24%
(30001-40000) at 21%
(Over 40001) at 18%
But if the result is less than 0 then I need the cell to show 0.
Is there a formula for this?
Thanks in advance.
|