Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

35% profit set

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nicholas hall - 14 Apr 2007 21:36 GMT
I use excel a bit, but I am still learning.

Here is the thing I want to try to do:

I have a product that costs X amount I want the said product to have a 35%
total clear profit after VAT.

I want a cell to have the trade price, the next cell to show the VAT for the
trade price, A cell to show the selling price (with the mark up), a cell
with the VAT for the selling price and finally a cell where I could set the
mark up value in percents. So if I change the percent value in the percent
cell it shows a different value in the selling price?

I wondered if anyone could help me with this?

Any help would be gratefully accepted.

NIK
Franksta - 16 Apr 2007 15:40 GMT
Kinda hard to illustrate but I think this is it. this is the formula that I
have used.

A2 = Trade Price
B2 = VAT %
C2 = Trade Price + VAT%
D2 = Markup %
E2 = Markup Price
F2 = Markup +VAT

formula for C2 is =A2+(A2*B2)
formula for E2 is =A2+(A2*D2)
formula for F2 is =E2+(E2*B2)

At least, that is what I think I understand from your question. Hope that
helps.

>I use excel a bit, but I am still learning.
>
[quoted text clipped - 14 lines]
>
> NIK

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.