Forum Discussion
data validation on two cells gives result in third cell
Hi,
The Weight Tracker is look great 🙂
So to explain, taking an Old English, she weighed in at 15.3Kg, her target weight is 23 to 27Kgs
Which means she is between 7Kg and 11.7Kg under her true weight.
In C10 it would give the difference from the weight and target weight
C11 it would give the date to the target weight in this case 23 to 27Kg if she gains 1 Kg a week, 7 to 11.7 weeks
Sorry if am not explaining myself right.
SergeiBaklan @Peter Bartholomew
Thanks to both of you for your support, however, I'm lost.
Also, I will be adding additional breeds as and when known so the B, C and D columns will increase.
To lessen my confusion see below
If you don't mind I converted Ideally Weight to Table. With that if you add/remove data no need to change the formula which could be
=INDEX(IdeallyWeight,MATCH(C5,IdeallyWeight[BREED],0),MATCH(C6,IdeallyWeight[#Headers],0))Brilliant!! AWESOME!!
However,
What does 'Unprotected Formula' relate to?
Also, for reasons the (B10 Kgs to) and (B11 Target date) is not displaying now, on the WeightGoals Tab, this worked out the Kgs difference + or - from the (Start Weight C4) and the (Target Weight C7) and entered it into C10 then used the value in (C8 Kgs per week) to give a target date in C11.
So with Doberman selected weight 15.3Kgs, gaining (1Kg per week), it would give a value of (C10 Kgs to 14.2 - 20.7) , which would give (C11 Target Date 16th April to 28th May).
It would workout a + or - value for gain or lose weight.
I hope I've explained myself fully, I know what I'm looking for in my head, it's putting it down in words.
I touched nothing but formula.
Unprotected formula - cells in your sheet are unlocked, don't know why. That means if you protect the sheet, these cells will be editable. That's what the alert says about. I locked the cell, but only this very cell, since don't know what is the logic behind unlocking. To lock/unlock select cell(s), Ctrl+1 and choose desired setting in the Protection tab.
B10 and B11 - not sure what you'd like to display here. Your initial formula is
=IF(COUNT(C4:C7)<2,0,C4-C7)*TypeMultit counts numbers in C4:C7. Since only Start Wight is the number in the range, it returns 1, thus result is zero. What it shall be here?
Hi,
The Weight Tracker is look great 🙂
So to explain, taking an Old English, she weighed in at 15.3Kg, her target weight is 23 to 27Kgs
Which means she is between 7Kg and 11.7Kg under her true weight.
In C10 it would give the difference from the weight and target weight
C11 it would give the date to the target weight in this case 23 to 27Kg if she gains 1 Kg a week, 7 to 11.7 weeks
Sorry if am not explaining myself right.