Multi percentage Calculation
Closed
Winndixie
Posts
20
Registration date
Monday 10 March 2014
Status
Member
Last seen
28 September 2018
-
27 Nov 2014 à 08:20
Winndixie Posts 20 Registration date Monday 10 March 2014 Status Member Last seen 28 September 2018 - 4 Dec 2014 à 08:46
Winndixie Posts 20 Registration date Monday 10 March 2014 Status Member Last seen 28 September 2018 - 4 Dec 2014 à 08:46
Related:
- Multi percentage Calculation
- Vat calculation excel - Guide
- Calculation is incomplete. recalculate before saving - Guide
- Electrical calculation software free download - Download - Calculators
- Multi touch windows 10 - Guide
- Percentage formula in excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
28 Nov 2014 à 10:11
28 Nov 2014 à 10:11
Most easy approach would be to to have only one column for %age
in that you can use formula as
=IF(OR(D1="", E1=""), "", E1 *VLOOKUP(D1,L:M,2,FALSE))
How ever, if you must have all those columns, then you can use similary vlookup, with error handling or use IF statement for each cell
in that you can use formula as
=IF(OR(D1="", E1=""), "", E1 *VLOOKUP(D1,L:M,2,FALSE))
How ever, if you must have all those columns, then you can use similary vlookup, with error handling or use IF statement for each cell
29 Nov 2014 à 06:07
the formulas was very helpful in my other workbook :)
but in this workbook, I need to classify which the percentage had been charge by the type when I showing to my boss.
Do have others formulas can make it??
thank you :)
2 Dec 2014 à 05:56
=IF(OR(D1="", E1=""), "", IF(ISERROR(VLOOKUP(D1,L:L,1,FALSE)), "", E1 *VLOOKUP(D1,L:M,2,FALSE)))
Formula is saying
1. If either D1 or E1 is blank, then show blank
2. If the value in cell D1 is not found in column L, then an error would happen. This is checked. If error occurred, then show blank
3. use the formula to calculate
4 Dec 2014 à 08:46
Have a Nice day !!
the formula is work...but my column D & E will not be blank because I need to fill the type to classify the percentage charges... so every time I change the type then I need the a formula to help me auto run the percentage that charge
e.g
- when every time changing the type .... percentage column auto running the percentage
-just like when change to B .... then column 1.2% will showing the value and others showing " - " or blank. If change to M then showing at the column 1.7% then 1.2% and 2.5% column auto showing "-" or blank.
is it possible to set a formula like this??? many times I had tried but still erro ...
Thanks & regards :)