2 Replies Latest reply: Nov 28, 2012 7:52 PM by Michael Stancato
Michael Stancato Level 1 (0 points)

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