Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Payroll Spreadsheet IF Function

  • 12-04-2011 8:33pm
    #1
    westendgirlie
    Closed Accounts Posts: 2,125 ✭✭✭


    Hello all,

    I'm doing up a spreadsheet for my b/friend who has managed to get some temporary work. All he has to do is put his hours into the timesheet and the wages should compute themselves.

    Only problem is.....I can't for the life of me remember how to do "IF" function correctly for PRSI !!!

    I know i want to say..... IF O3 (excel column) is >352 then true is O3-127*4% if false then zero.

    Somehow it's giving an incorrect figure. Help please :)


Comments

  • #2
    JoeTurner
    Registered Users, Registered Users 2 Posts: 201 ✭✭JoeTurner


    =IF(O3>352,(O3-127)*0.04,0)

    Try this, hope it works


  • #3
    westendgirlie
    Closed Accounts Posts: 2,125 ✭✭✭westendgirlie


    JoeTurner wrote: »
    =IF(O3>352,(O3-127)*0.04,0)

    Try this, hope it works


    Thank you :) After staring at it for too long, I got a glass of wine and worked out where I went wrong! The incorrect calculation was 4% of €127 but I stuck the brackets in the correct place and all is as it should be now.

    Just gotta work out a better way of calculating the USC now!


Advertisement