HELP! Need to show amount of loss in totals by weekly numbers...

[AliciaMeier]

I am making a "biggest loser" spreadsheet where I have the starting weight in B3, cells C3-M3 will have the weigh ins with each week. In cell N3 I have the total loss. I would like the total loss to show correctly with each week.
Ex: start weight is 150, the first weigh in is 149 - total loss should say 1.

The problem I am running into is keeping the total running per week. I attempted an =IF formula, but it does not seem to work after the second week. I posted the formula I attempted below. If this is the right way to go about it, but I am not using the right cells/functions please let me know. If another (or simpler) formula will work out better- I am open to ANY ideas!

Here is my initial failed formula:
=IF(C3>0,B3-C3,0)*IF(D3<C3,B3-D3,B3-C3)*IF(E3<D3,B3-E3,B3-D3)*IF(F3<E3,B3-F3,B3-E3)*IF(G3<F3,B3-G3,B3-F3)*IF(H3<G3,B3-H3,B3-G3)*IF(I3<H3,B3-I3,B3-H3)*IF(J3<I3,B3-J3,B3-I3)*IF(K3<J3,B3-K3,B3-J3)*IF(L3<K3,B3-L3,B3-K3)*IF(M3<L3,B3-M3,B3-L3)

Thank you in advance!

[etaf]

would you just be looking for the minimum value in the cells

=B3-MIN(C3:M3)

i guess that will not show the actual weight - just the most weight loss during the process

I suspect you just need to see the last weight entered

edit - changed formula
=IFERROR(B3-LOOKUP(1E+100,C3:M3),"")


150, 149,146,149,150,130,140,150
for the example above the weight loss is zero
started at 150 and ended at 150
or the most lost
150 - 130 - the min value so 20

EDIT
actually the IF is not working
probably just use
=B3-LOOKUP(1E+100,C3:M3)
if you dont mind errors , until week 1 is entered

or use
=IFERROR(B3-LOOKUP(1E+100,C3:M3),"")

[AliciaMeier]

Etaf - your second formula is exactly what I am looking for! Thank you very much for helping with this- I have been trying to figure it out for way too long now!

Another question-

Is there a way to get the percentage of weighloss from this data? To get weight loss percentage, it would be the Start weight (B3) - Current weight (=B3-IF(COUNT(C3:M3),LOOKUP(1E+100,C3:M3),"") ). Then you divide the difference by the start weight again (B3) and multiply that answer by 100.

I think I am in excel overload...

[etaf]

=iferror(((B3-LOOKUP(1E+100,C3:M3))/b3)*100,"")

if you format as percent in the cell then you do not want the * by 100
=iferror(((B3-LOOKUP(1E+100,C3:M3))/b3),"")

NOTE

i changed this
(=B3-IF(COUNT(C3:M3),LOOKUP(1E+100,C3:M3),"") )
as it gave an error as was not error correcting correctly
have a look at my previous post - for the edits

[AliciaMeier]

Ah! The relief.. and just in time for me to get out of work at 4:30. Thank you very much for your help. Both formulas work perfectly. I really appreciate it!

[etaf]

your welcome, have a great evening