Percentage Work
Solved/Closed
Winndixie
Posts
20
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 28, 2018

Dec 26, 2014 at 05:25 AM
RayH  Jan 6, 2015 at 11:45 AM
RayH  Jan 6, 2015 at 11:45 AM
Related:
 Marksheet percentage formula in excel
 Percentage formula in excel marksheet  Guide
 Number to words in excel formula  Guide
 Date formula in excel dd/mm/yyyy  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 How to take screenshot in excel  Guide
1 response
I'm sure there is a better way to do this, there has to be. But in the meantime this works ok.
copy into cell F2 and drag it down and across to fill in the other cells.
copy into cell F2 and drag it down and across to fill in the other cells.
=IF(OR($D2="",$E2=""),"",IF(ISNA(MATCH($D2,$L$3:$L$6)),"",IF(INDEX($M$3:$M$6,MATCH($D2,$L$3:$L$6))=F$1,$E2*INDEX($M$3:$M$6,MATCH($D2,$L$3:$L$6)),"")))
Jan 1, 2015 at 04:34 AM
the formula is work!! thank you very much. :)
but I facing another problem is after I paste the formula the BAL showing "#VALUE!" my formula at the BAL was =E2F2G2H2, the BAL can't read the deduction ??
thx
Jan 1, 2015 at 12:30 PM
Sorry, I didn't look at that originally.
Here is the solution to that:
=E2SUM(F2:H2)
Jan 5, 2015 at 11:15 AM
my work book is work!!
Thank you very much !!
Jan 5, 2015 at 09:28 PM
Jan 6, 2015 at 11:45 AM