how can clear Value Error in paryroll.

excuemedubai

New member
Joined
Jun 16, 2015
Messages
8
Reaction score
0
Points
0
i m trying to update our company Payroll. but i m getting value error in total Gross Salary-(Q7) colomun and getting same error in Net salary -(U7)coloum. i know i entered some if formula in Other Allowance (k7) , Accomodation Allowance (L7) and Overtime Amount (O7).

even i like to get formula to round off value.

more information, please check attached file.

plz help me...
 

Attachments

  • payroll-test.xlsx
    21.6 KB · Views: 9
Hi,
plz see the attachment. is this help you ?
 

Attachments

  • payroll-test(1).xlsx
    21.6 KB · Views: 13
its nice...but how you soloved this problem...let me knw...i try to put same formula in Q7==SUM(J7:M7)+O7+P7 but answer is Value error

have changed any settings in Other Allowance (k7) , Accomodation Allowance (L7) and Overtime Amount (O7)?
 
Hi,
in cell O7, i have changes the formula =IF(N7="",0,F7/30/9*1.25*N7).

Now I have attachment another one file. In which you find without changing your current formula in cell O7. I have changed in cell Q7. i.e, =SUM(J7:M7)+ISERR(O7)+P7.

Plz see the attachment.
 

Attachments

  • payroll-test(2).xlsx
    21.5 KB · Views: 5
thank you Mr.Sambit...
but again i m faceing problem....
plz check my attached recent file here..i m getting Variance in my gross salary (p6) and Net salary (u6). in U6 i m getting value # error also.

(variance u can find in p15- it should be-3736.67 but its showing only 2986. its not couting amount which entered in o 15)
 

Attachments

  • Excel-Payroll-Calculator.xls(updated-04-07-2015).xlsx
    45.2 KB · Views: 11
Last edited:
Hi excuemedubai,
plz see the attachment. is this solve your problem ?
 

Attachments

  • Excel-Payroll-Calculator.xls(updated-04-07-2015)(1).xlsx
    46.2 KB · Views: 16
Back
Top