Price Increase by cell percentage
Hi All,
I'm trying to increase an actual price by a certain percentage, based on a cell's value
Example C1 contains the percentage value i want to increase the invoice price in D4 by.
Currently the formula is "=SUM(D4/100)*105" but i would like it to be based around C1 input.
I've attached a worksheet for an example.
Please can someone advise?
Regards,
Caf20012
Wrong answered
Like this ? =D4*(1+$C$1)
PS the SUM function in your above formula is not necessary
Perhaps
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Solved by Fotis1991.
Thank you!
Last edited by caf20012; 10-16-2014 at 03:24 AM.
caf20012
It worked fine for me check the updated file .
Punnam
Yes, exactly the same as mine...Originally Posted by caf20012
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks