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

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 100In cell E2 enter the formula: =((A2*B2)/C2)*D2

See how that works.

MIKE

Thank you so much you have fixed my problem :-)

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.

DerbyDad03

Office Forum Moderator

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

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History