Solved Excel: Find List Price Based On Exchange Rate

December 29, 2013 at 14:17:12
Specs: Windows 7
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

Report •

December 29, 2013 at 16:20:17
✔ Best Answer
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)*D2

See how that works.


Report •

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

Report •

December 30, 2013 at 07:56:32

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.

Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question