Subtraction Question

  • Thread starter Thread starter Guest
  • Start date Start date
I don't want to subtract just G2 from A2. I'd like to subtract A2 thru G2
(A2:G2)
 
=A1-SUM(A2:G2)

???

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Subtracting C2 thru G2
Example: If C2 had 3436, D2 had 3395, E2 had 3376, Then answer in F2 would
be 60
Still can't figure this one out! Thanks so much in advance for any help!!
 
Subtracting C2 thru G2
Example: If C2 had 3436, D2 had 3395, E2 had 3376, Then answer in F2 would
be 60
Still can't figure this one out! Thanks so much in advance for any help!!
Click to expand...

=MAX(C2,D2)-E2

But I think you are not giving us enough information to be able to give you a
proper answer.


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
Excel formulas + subtraction of days 2
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Simple Math ? 6
Leave Blank If No Data 6
Column sum incorrect upon subtracting 6
subtracting in Excel 2
I want to add or subtract a range of cells 2

Back
Top