I am trying to find the lowest value of cell B1 that is constantly being updated. If B1 is lower than A1, then A1 will be replaced with a new B1 value. And if B1 is higher than A1, then A1 retain its previous updated number. I am not sure if this can be done with function, script, or if it's even possible to do.
I have this in Cell A1 "=if(A1<B1,B1,A1)"
It's giving me error and I am guessing it's because the "value_if_false" is pointing to the cell I put the IF statement in, thus creating an infinite loop.
Aucun commentaire:
Enregistrer un commentaire