Skip navigation

How to make a formula to calculate Artist Profit / Gallery Commission Percent / Gallery Price

378 Views 2 Replies Latest reply: Nov 28, 2012 7:52 PM by Michael Stancato RSS
Michael Stancato Level 1 Level 1 (0 points)
Currently Being Moderated
Nov 28, 2012 5:29 PM

I'm selling paintings in a gallery. The gallery takes a 40% commission. I'm told to adjust my price so that I receive what I want after a commission is taken. How do I make a formula in iWork Numbers to calculate this  equation:


  Gallery Price              100

-------------------  =   ---------------

Profit for Artist              60



I want a spreadsheet that has a columns like this:


Profit for Artist  |   Gallery Commission %  |  Gallery Price

$1000.00         |                   40%               |      $1666.00


I think those numbers are right.



G5 PowerMac (Late 2005), Mac OS X (10.5.8), G4 iBook, iPod Mini, iPod Shuffle 1st Gen


More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.