If Formula 1% or 10% Choice

[muhammad susanto]

hi all...

i am looking formula to calculate this data below, have only 2 choice clue 1% or 10%
if 1%, the math formula 100/101*data, otherwise if 10% the math formula 100/110*data

clue	data	expected result
1%	5000	=100/110*5000
10%	3000	=100/101*3000
1%	2000	=100/101*2000
1%	100	=100/101*100
1%	4500	etc..
10%	1200
etc..

<thead>
</thead><tbody>
</tbody>

any assistance , much appreciated...

m.susanto

 

[AliGW]

Hi!

Lines one and two of your example table make no sense.

 

[BravoSierraTango]

Line 1 and two seem to be mixed up. You'd have to exchange the 110 and the 101.

Best regards
BST

 

[muhammad susanto]

hi..

yes you're right, should be :
for lines one 100/101*data

 

[AliGW]

And line 2???

 

[AliGW]

This copied down:

=100/((VALUE(A2)*100)+100)*B2

 

[muhammad susanto]

hi AliGW, working well...

once again, for math formula :
1%----1/101*data
10%---10/110*data

how is excel formula? could you help me..

 

[AliGW]

I've given you an Excel formula!

 

[muhammad susanto]

hi..

this different situation
1%----1/101*data
10%---10/110*data

 

[AliGW]

hi..

this different situation
1%----1/101*data
10%---10/110*data

That is different to the example in your opening post. You really are not making yourself clear. Post a table with ALL the various combinations and outcomes you are looking for, then I will have a look, but I'm not going to keep offering solutions and then finding that the goalposts have shifted.