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

Help with a nested formula

  • 01-02-2011 2:47pm
    #1
    AnneClare1
    Closed Accounts Posts: 3 ✭


    Hi There, apologies first if I am in the wrong forum but I have not posted on here for several years. I have an interview tomorrow and will most likely be tested on excel. I've been out of the job market for a couple of years and have forgotten how to do a nested formula. Can anyone please help by firstly letting me know how to do a nested formula in the F1 section and if they can help by advising me of a formula for the following row 2 Column 6.

    Wk No Pay Cum Pay Cum Cut Off Tax @ 20 Tax at 41%
    1 600 600 663.48 120
    2 800 1400 1326.92

    I've managed to do the tax rate of 20% by the following formula =IF(D2>C2,C2*20%,0) but I now need to be able to add a formula which will show Row 2 at 1400.00 - 1326.92 and will show cum tax @20% as 265.38 and Cum Tax at 41% as 29.96. Any help will be greatly appreciated.


Advertisement