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.
PeterBartholomew1 , thank you.
I'd modify a bit
= LET(
split, FIND("to", TargetWeight),
lowerLimit, --TRIM(LEFT( TargetWeight, split-1 )),
upperLimit, --TRIM(RIGHT(TargetWeight,LEN(TargetWeight)-split-2)),
result,
IF( StartWeight < lowerLimit,
TEXT(1 - StartWeight/lowerLimit, "0%") & " under weight",
IF( StartWeight > upperLimit,
TEXT(1-upperLimit/StartWeight, "0%") & " over weight",
"Within normal bounds")),
result
)
Oops! Thanks for the tidying up. I had been called for a meal and clearly didn't pay enough time to checking.
PeterBartholomew1 , hope you enjoyed the meal
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))