another condition whenever the cell is blank

Copper Contributor

I'm having trouble with my project. I want to compute their weight status but I have 4 weight records.

 

I have this problem that I wanna solve:

 

if the 4th weight is blank then it will directly go to the 3rd weight same here if the 3rd is blank it will go to the 2nd and so on. 

laj_16_2-1677485472852.png

 

 

Here is the code for my prediction

 

 

laj_16_1-1677484389671.png

here is my data where I compare my prediction

laj_16_3-1677485630803.png

 

 

0 Replies