Calculations in table cell description of problem

E

Edith

Template form built in Word XP: I have cell addresses of
F5 through F10 that are totaled in cell F12 with =sum(....)

I now need to subtract cell F13 ( I input a number) from
F12 and put the results in F14 if it is a negative number
or cell F15 if it isn't. Example: F12 is the total of sum
above 40, F13 is 32 and the results should display in cell
F15. Second example: F12 is the total 28 and F13 is 30,
the results should display a negative number in F14.

I can't seem to build the formulas that will do that. I do
not want to use Excel. This is a business template and
they require Word XP.
 
G

Greg Maxey

Edith,

You will need a different formula in F14 and F15.

F14
{ IF { =(f12-f13) } < 0 { =(f12-f13) }"" }

F15
{ IF { =(f12-f13) } >= 0 { =(f12-f13) }"" }
 
E

Edith

Not working, I assume the < or > 0 means to input 30 or 32
(or do I leave it at 0). I typed exactly spaces and all,
but when I try to use the form it skips cell F14 and F15.
I have my options set to calculations, and 0.00 number
format.
 
G

Greg Maxey

Edith,

I am sorry if I confused you with less than a sufficient
answer. I assumed that you would realize that the
formulas I provided were contained in a Word field
inserted in cells F14 and F15. These are "not" formfields.

Your formfield in cell F13 should be set to calculate on
exit. The two IF field formulas I provided should be
entered exactly as written using CTRL+F9 to insert the
field code brackets { }.

Well not quite exactly, if you want a number format 0.00
then change the formulas to:

F14
{ IF { =(f12-f13) } < 0 { =(f12-f13) \# 0.00 }"" }

F15
{ IF { =(f12-f13) } >= 0 { =(f12-f13) \# 0.00 }"" }

You now confuse me with your assumption < or > means 30 or
32? Here is how this process works.

You have a sum calculated in F12. You insert a variable
in F13. You want to subtract the variable in f13 from f12
(hence the need to "calculate on exit") you want the
result displayed in F14 or F15 based on a condition.

The condition for F14 is "IF" the result "{ =(f12-f13) }"
is "<" (read as less than) "0" "THEN" display the
result "{ =(f12-f13) }" "ELSE" (read as otherwise)
disply "" (read as nothing)

F15 is similiar except the comparison is "greater than or
equal to 0" otherwise both F14 and F15 would be blank if
f12-f13=0

HTH and clears things up
 
Top