By the way, having all of the Phonecalls and Receipts in single rows makes it easer to drag the other formulas to the right to prevent having to write so much. There is a little dot in the lower left corner of a selected box.
Quote:
AgentZero said:
OK, I've figured out everything up to and including Sub-Total (wasn't too hard really), but the reciepts bit is giving me a bit of trouble.... Any suggestions of a formula for that?
|
If you make them and the phonecalls be in singular rows, you get:
Bill Total + [Name] Phonecalls + Average Receipts - [Name] Receipts