LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Daddys Girl
 
Posts: n/a
Default insert two formulas one cell

I am creating a spreadsheet for my dad's check cashing business. I have three
cells: "AMOUNT", "FEE", "CASHED".

He charges an average of .012 or each check. so I enter the formula
"=PRODUCT('AMOUNT*.012) into the "FEE" cell. then I calculated in the
"CASHED" cell "=SUM('AMOUNT'-'FEE') for the total.

Sometimes he doesn't stick to his .012 fee. He wants to be able to put in
the actuall amount he cashed and come up with the fee. Can I not create a
circular reference to the "FEE" cell and have a function that will also
calculate the amount he charge? "FEE"=SUM('AMOUNT'-'CASHED')

How do I do that?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update of cell values after insert row? dazman Excel Worksheet Functions 2 August 23rd 05 07:07 AM
INSERT ROWS WITHOUT SCREWING-UP FORMULAS! BILL GATES - I WANNA WORD WITH YOU! Excel Worksheet Functions 1 March 4th 05 01:32 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
Formulas (If linked data is not null, then insert "Complete" in ce Task Lead Nicole Excel Worksheet Functions 3 January 10th 05 06:25 PM
Cell Formats in formulas C. Lewis Excel Discussion (Misc queries) 1 January 5th 05 06:37 PM


All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"