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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History