How does one add a percentage to a number? If I have 100 and I want to add 15% and get a total, what formula would I use?
iMac, Mac OS X (10.7.3)
You can do something like this:
D2=B2*(1+C2/100)
this means in the cell D2 type the following "=B2*(1+C2/100)"... leave out the double quotes
You can do something like this:
D2=B2*(1+C2/100)
this means in the cell D2 type the following "=B2*(1+C2/100)"... leave out the double quotes
Thank you very much Wayne, you are more help that the function browser! 🙂
A simple percentage? How does one add a percentage to a number? If I have 100 and I want to add 15% and get a total, what formula would I use?
