Hello !
I`m a total "no idea" at excel, I really appreciate the help here !
I`m wanting to calculate a bonus of 30% of a given column of figures, negative figures to be given zero bonus.
Then another column after that as "net bonus", being taxed at 37%. Again not including the negative figures.
I`ve attached the spreadsheet here to show the last 2 columns I need help with.
demo-targets.xlsx
Here!
Put this in Cell G2 - =IF(F2>0,SUM(F2*30%),0)
Put this in Cell H2 - =G2-(G2*37%)
And drag down..
Cheers!
Deep Dave
I tried typing this into the cell, IF(F2>0,F2*30%,0)
saying if the value of F2 is greater than zero, then calculate the bonus as 30% of that figure. But nothings happening in the cell afte pressing enter...
thankyou that works perfectly. thanks so much.
try
G2=MAX(0,F2*30%)
H2=G2*(1-37%) OR G2*63%
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
You are welcome and thanks for your feedback
Actually i`ve just realized today, I want to "lock" the formula`s into the columns that have formula`s, so people cannot delete them by entering figures manually.
columns D,F,G, and H need to be locked from manual changes, they should only update when the other columns are changed...
How would I do this?
kind regards.
I cannot see where to mark this thread "solved" for the initial question..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks