=k2/100*5+k2
| Ozgrid Excel Help Forums & Excel Best Practices |
Hi all,
I have a Holiday Pay spreadsheet with 40 men on it. Coolum k lists the total pay and column L has his hourly rate on. There has just been a 5% increase on the hourly pay I don’t want to amend every mans individual pay, is there a quick way i can add 5% to the total pay or the hourly pay?
Thanks in advance
Kevin
=k2/100*5+k2
Regards,
Simon
In the unlikely event you don't get an answer here tryMicrosoft Office Help for FREE!
Please take the time to read these rules before posting!
You can use pasteSpecial - see the method explained in the article on PasteSpecial here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks