Formula for percentage calculation
Closed
XLFaith
Posts
2
Registration date
Monday March 31, 2014
Status
Member
Last seen
May 1, 2014
-
Apr 30, 2014 at 05:37 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 1, 2014 at 08:01 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 1, 2014 at 08:01 AM
Related:
- Formula for percentage calculation
- Excel marksheet percentage formula - Guide
- Vat calculation formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Calculation is incomplete. recalculate before saving - Guide
- Date formula in excel dd/mm/yyyy - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 30, 2014 at 04:18 PM
Apr 30, 2014 at 04:18 PM
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
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
Posts
2
Registration date
Monday March 31, 2014
Status
Member
Last seen
May 1, 2014
May 1, 2014 at 12:57 AM
May 1, 2014 at 12:57 AM
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
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
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 1, 2014 at 08:01 AM
May 1, 2014 at 08:01 AM
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
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