help

  • Thread starter Thread starter morethan
  • Start date Start date
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
 
=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?
 
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)
 
Back
Top