Percentage Formula Needed
Hi, a very easy question for you guys, i need to know how to add a Percentage to a total
example 1: in cell c25 i have my ammount eg 11,960
now i want to add 25% to it, then multiply it by 2%, so i get an answer of 299
example 2, in cell c11 i have my ammount eg 5000
i want to add 25% to it then multiply it by 2% then add 30 to it so i get an answer of 155
i can not work them out, can anyone help please
Hello,
Question 1 try this formula:
=(C29+(C29*0.25))*0.02
Question 2 try this formula:
=(C11+(C11*0.25))*0.02+30
Corine
A1 = 11960
A2 = 5000
B1 =(a1+a1*25%)*2%
B2 =(a2+a2*25%)*2%+30
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
thank you to you both, works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks