I'm trying to do this:
if cell B41 is greater than 0, then increase the value of this cell by 1 each time B41 is increased greater than 10 (i.e. 10, 20, 30, 40, 50...) increase the value by another 1 (i.e. 0=0, 1=1, 10, 11, 12...=1, 20, 21, 22...=2, 30,31,32,33...=3...)
=if(B41>0,(for every 10)+1,0)
I looked online for alternatives on how to do the formula and haven't found anything.
Aucun commentaire:
Enregistrer un commentaire