R
Richard
How do you subtract, example: A2:G2
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bigwheel
Richard said:How do you subtract, example: A2:G2
To subtract A2 from G2 enter the formula =G2-A2 into a cell
R
Richard
I don't want to subtract just G2 from A2. I'd like to subtract A2 thru G2
(A2:G2)
(A2:G2)
R
Ron Coderre
How about this:
=-SUM(A2:G2)
=-SUM(A2:G2)
B
Bob Phillips
=A1-SUM(A2:G2)
???
--
HTH
RP
(remove nothere from the email address if mailing direct)
???
--
HTH
RP
(remove nothere from the email address if mailing direct)
R
Richard
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!!
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!!
R
Ron Rosenfeld
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!!
=MAX(C2,D2)-E2
But I think you are not giving us enough information to be able to give you a
proper answer.
--ron