Forum Discussion
Multiple If statements question
I am trying to enter a formula that says if A1 - A2 > 784 then display whole number result + 1. If result is < 784 display 1. If A2 > A1 then write "Done". I'm filling boxes that hold 784 items. ...
Does this do what you want? It's not clear whether you want to use A2 or B1.
=IF(A2>=A1, "Done", ROUNDUP((A1-A2)/784, 0))