Formula for percentage calculation [Closed]

Report
Posts
2
Registration date
Monday March 31, 2014
Status
Member
Last seen
May 1, 2014
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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

3 replies

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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
Posts
2
Registration date
Monday March 31, 2014
Status
Member
Last seen
May 1, 2014

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
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!