I am trying to set up a formula to subtract from 2 different lines say column B and C have data in them
I want them to subtract from 90k
So 90k would be the starting number
B1 has 450 and C1 has 350
now my total has 89,200 but where i put my TOTAL at i want it to stay there not move from the cell.
What cell has the starting number?
If it's A1, would this formula suffice?
=90000 - B1 - C1
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks