Multi percentage Calculation
Closed
Winndixie
Posts
23
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 28, 2018

Nov 27, 2014 at 08:20 AM
Winndixie Posts 23 Registration date Monday March 10, 2014 Status Member Last seen September 28, 2018  Dec 4, 2014 at 08:46 AM
Winndixie Posts 23 Registration date Monday March 10, 2014 Status Member Last seen September 28, 2018  Dec 4, 2014 at 08:46 AM
Related:
 Multi percentage Calculation
 Calculation is incomplete. recalculate before saving  Guide
 Vat calculation formula  Guide
 Electrical calculation software free download  Download  Calculators
 Excel marksheet percentage formula  Guide
 Position calculation formula in excel ✓  Office Software Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 28, 2014 at 10:11 AM
Nov 28, 2014 at 10:11 AM
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
Nov 29, 2014 at 06:07 AM
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 :)
Dec 2, 2014 at 05:56 AM
=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
Dec 4, 2014 at 08:46 AM
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 :)