#1
|
|||
|
|||
Help with formula and math involved with totaling data for invoicing
I’m working on a spreadsheet to help track the hundreds of small orders and their revisions that we will be getting over the next few months. The purpose of the spreadsheet is to help determine what to invoice by the end of each order. I attached a copy of what I am working on but I need help with a couple of the formulas and some of the math involved to get to the next level.
Long story short, the pricing agreement established by my customer is as follows: 1. $300 startup base cost for all orders up to 3 revisions (see column K). $50 for each revision after 3. 2. 1 free WB (white body) per revsion (see column E). Additional WB’s are $25 each. 3. All digital orders (see column F) are $3.50 per square foot (see column N). I need help with figuring out how to figure revisions past the 3rd one into what to invoice. I also need some help fine tuning my math and maybe making them formulas. For example, what if they order 0 WB’s? I need a better equation/formula. Any help would be much appreciated. |
#2
|
|||
|
|||
Quote:
Base = 300 For Line 4: RevCost = Max(K4-3,0)*50 WBCost = Max(E4-K4,0)*25 DigCost = 3.5*H4*G4*F4/144 |
#3
|
|||
|
|||
Thank you, gebobs. This formula/equation should work exactly for what I need.
|
Tags |
formula help, mathematics, total |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Totaling on hours problem | 56_kruiser | Excel | 6 | 09-04-2014 07:01 PM |
A simple select for a given math formula | Jo-NathanBSChE | Excel | 1 | 04-16-2013 03:10 AM |
Can't get formula to recognize correct data | cklassen | Excel | 1 | 05-19-2012 01:25 AM |
How do I embed a Math formula? | DMD | Word | 0 | 11-17-2009 12:37 PM |
Outlook CONTACTS used for invoicing | Garratt | Outlook | 0 | 02-16-2006 06:33 PM |