I'm trying to build a calculator that will break down a calculation. So, say the value was 1000. I want to use one table, below, to determine the percentage

0- 200 = 0%

201 -500 = 10%

501-1000 = 20%

1001 -5000 = 30%I want it to break down the 1000 into the thresholds so:

200 @ 0%

500 @ 10%

300 @ 20%.hope that makes sense. I've tried using the IF formula but i don't understand what i'm doing.

Thanks

C

Try this: The syntax of an IF() function is:

IF(logical_test, [value_if_true], [value_if_false])

You can

nestone IF() function within another,

see if you can follow the logic.using these numbers:

0 - 200 = 0% 201 - 500 = 10% 501 - 1000 = 20% 1001 - 5000 = 30%With your value in cell A1

enter the formula in cell B1=IF(A1<=200,A1,IF(A1<=500,A1+A1*10%,IF(A1<=1000,A1+A1*20%,IF(A1<=5000,A1+A1*30%,""))))

MIKE

message edited by mmcconaghy

Ask Your Question

Weekly Poll