Results 1 to 8 of 8

Thread: how can clear Value Error in paryroll.

  1. #1

    Post how can clear Value Error in paryroll.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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...
    Attached Files Attached Files

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz see the attachment. is this help you ?
    Attached Files Attached Files

  3. #3
    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)?

  4. #4
    some one help me?

  5. #5
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    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.
    Attached Files Attached Files

  6. #6
    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)
    Attached Files Attached Files
    Last edited by excuemedubai; 2015-07-04 at 04:35 PM.

  7. #7
    Neophyte ncmay's Avatar
    Join Date
    Apr 2015
    Location
    Massachusetts, USA
    Posts
    1
    Articles
    0
    Try replacing the formula in cell U6 with =SUM(P6,S6) then copy down.

  8. #8
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi excuemedubai,
    plz see the attachment. is this solve your problem ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •