=If(Sheet1!B3>7, IF(MOD(Sheet1!B3/6)<QUOTIENT(Sheet1!B3/6), Roundup(Sheet1!B3/6,0),Rounddown(Sheet1!B3/6,0)),1)
This returns a "1" as expected for values 7 or less, but an error for all values 7 or greater.
I want it to return a 1 if the value is not greater than 7, and if it is greater than 7 I want it to evaluate whether the remainder of the value divided by 6 is less than the quotient for the value divided by 6. If it is, I want it to round up the value divided by 6 to the nearest ones place digit. Otherwise, I want it to return the value divided by 6, rounded down to the nearest ones digit.
Solved by A. A. in 28 mins