Like in case of sum we use "=SUM(B2:B200)" in the field na? Similarly wat should be use for subtracting
And BTW how to set user defined formula's for a particular field?
Plz help me
2007-01-16 17:43:08 · 3 answers · asked by Steelbug 1 in Education & Reference ➔ Homework Help
Do not use SUM but go to the formula, click a chosen block where you want the result to appear, then click the fx, then you click the B2,minus sign,B200 then click the check sign. Good luck.
2007-01-16 18:00:23 · answer #1 · answered by wacky_racer 5 · 0⤊ 0⤋
One of the fields needs to be assigned a negative:
=SUM(-B2,B200), or =-SUM(B2:B200) for a negative total. As far as I know you can't, without VB subract B2 from B3 from B4, etc.
I don't understand what you are asking in your second part.
2007-01-17 01:58:07 · answer #2 · answered by Anonymous · 0⤊ 0⤋
=B2-B200, if B2 and B200 are the fields who difference you want to find.
2007-01-17 01:46:16 · answer #3 · answered by question 2 · 0⤊ 0⤋