Forum Discussion

Jibsman's avatar
Jibsman
Copper Contributor
Mar 04, 2025

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. If I need 5000 items and have 0 so far, I want to divide it by 784. Since the result is 6.3, I will have to include a partially filled box. Thus the +1.  The result will be 7.

A1 is how many I need.

A2 is how many I have so far. Starts at 0.

Once I have enough or more than enough I will enter "Done".

My formula so far is =IF(A1-B1>0,((A1-B1)/784),"Done"). That only gives me Done if B1 is > A1.  I need to fill in the rest.

I hope all this makes sense!

1 Reply

  • 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))

Resources