i need to create a formula that will track wieghts of people. If they gain
wieght I need it to show a positive number and if they loose weight I need it
to show a negeative for the next 6 months. weights done monthly

=A2-A1 will return a positive number if A2 is larger than A1, and will
return a negative number if A1 is larger than A2. Perhaps you'd like to
clarify your question?
--
David Biddulph

"morethan" wrote in message
...
i need to create a formula that will track wieghts of people. If they gain
wieght I need it to show a positive number and if they loose weight I need
it
to show a negeative for the next 6 months. weights done monthly

Assuming that you have the original weight in A1 and all ensuing weights in
b1,c1,d1,e1,f1,g1. then the following will subtract the most recent weight
from the original weight.

=A1-LOOKUP(1E+100,B1:G1)

"morethan" wrote:

i need to create a formula that will track wieghts of people. If they gain
wieght I need it to show a positive number and if they loose weight I need it
to show a negeative for the next 6 months. weights done monthly