# Solved Excel: Find List Price Based On Exchange Rate

December 29, 2013 at 14:17:12
Specs: Windows 7
 Hi, I am trying to work out the formula for a spreadsheet I have, I need to know a retail price from the following information, List price, times by 5% then divide by xchange rate and times by Qty

See More: Excel: Find List Price Based On Exchange Rate

#1
December 29, 2013 at 16:20:17
 Without any examples of what you expect, try this:``` A B C D E 1 List Price 5% Xchng Rate Qty Total 2 10.00 .05 .73 100 ```In cell E2 enter the formula: =((A2*B2)/C2)*D2See how that works.MIKEhttp://www.skeptic.com/

Report •

#2
December 29, 2013 at 17:24:15
 Thank you so much you have fixed my problem :-)

Report •

#3
December 30, 2013 at 07:56:32
 Waveney,This is just a posting tip:When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "Formula for a Spreadsheet" we wouldn't be able to tell one question from another and the Archives would essentially be useless. I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.Thank you for your understanding.DerbyDad03Office Forum Moderator

Report •
Related Solutions