help

M

morethan

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
 
D

David Biddulph

=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?
 
A

Atishoo

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)
 
Top