auto - time n% depend on the value of column

how to set the auto *(times) N% at column B, when the value of the column A.

example:

column A column B (result)
100 100 * 1%
500 500 * 5%
700 700 * 7%
200 200 * 2%
50 50 * 0%

0 - 99 = 0%
100 - 199 = 1%
200 - 299 = 2%
...

Hi

Try

=A1*INT(A1/100)/100

rylo

Originally Posted by rylo

Hi

Try

=A1*INT(A1/100)/100

rylo

thx a lot!

if the value is below, what is the formula can i do?
0 - 399 = 4%
400 - 799 = 7%
800 - 1599 = 15%....

Selina

Depending on how many variations you have, I'd go down the track of using VLOOKUP and building a lookup table.


rylo

Originally Posted by rylo

Selina

Depending on how many variations you have, I'd go down the track of using VLOOKUP and building a lookup table.


rylo

rylo
i don know how to do with this formula (vlookup) and how to set the table for it.

can you show me step by step or any example to show me, because i'm not good in excel .

thx

Selina

vlookup is the way to go

If you have in e2:f4
0 4%
400 7%
800 15%

in cell b1
=vlookup(a1,$e$2:$f$4,2)

this can then be copied down

regards

Dav