Hi,
I am using a new spreadsheet in a new job. The formula I need amended is set to discount the prices by 27.5% and I need to amend it to 20%. The current formula is
=L343*'Wholesale figures'!E7/100
anyone got an idea on how to amend this to 20%???
Thanks in advance,
Nikki
What value is in 'Wholesale figures'!E7 ? It might be 72.5%, which is 100%-27.5%, in which case you should change the value to 80% to get a reduction of 20%.
Hope this helps.
Pete
What is in E7 and L343 ?? If either value is 72.5, amend to 20. If they are something else, then I'm confused.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Last edited by Glenn Kennedy; 12-05-2014 at 09:59 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks