Formula for percentage calculationClosed

Question

Needed a formula in A which will be then pulled down throughout the
column.
Wanted the result in A where B multiplied by C & D and deducting the value in T.
Value in T actually is for percentage. That much percentage should be deducted from the 
value obtained after multiplying B C D and put it in A.

I hope it is clear

Thanks

Mazzaropi · Answer

XLFaith, Good evening. 

Scenario:
B1 --> 20
C1 --> 5
D1 --> 6
T1 --> 10%

Try to use it:
A1 --> =(B1*C1*D1)*(1-T1)
A1 --> =(20*5*6)*(1-10%)
A1 --> =600*90%
A1 --> =540

Is this what you want?
I hope it helps. 
 --
Belo Horizonte, Brasil.
Marcílio Lobão

XLFaith · Answer

Example if
B is 2
C is 500
D is 2
T is 25 (in T only the number is mentioned and not the % sign)

The answer in A should be 1500

Thanks

Mazzaropi · Answer

XLFaith, Good morning.

Using your new explanation.
Try to use it:

A1 --> =(B1*C1*D1)*(1-T1/100)

A1 --> =(2*500*2)*(1-25/100)
A1 --> =2000*0,75
A1 --> =1500

Is this what you want?
I hope it helps.
 -- 
Belo Horizonte, Brasil.
Marcílio Lobão

Formula for percentage calculation

3 responses

Similar discussions

Subscribe To Our Newsletter!