Formula / Solution / Idea - If cell exceeds a value move remainer to another cell..

Kerry Kubaszyk

Greetings…..

Need a formula or solution that if the value of a cell exceeds 10, move the remaining to a different cell. In this example, I have columns named C1, C2, C3, C4 and Time, and a form that collects the data from the Time field. A user goes to the form, they add 15 into the Time field, I would like 10 placed in C1 and 5 in C2. When the user goes back to the form again and updates time by adding 20 hours, I need C2 to now be 10, C3 now 10, and C4 5, etc…

Any help or ideas would be much appreciated.

bisaacs

Hey @Kerry Kubaszyk,

For C1, do something like this:

=IF(Time@row > 10, 10, Time@row)

Then, C2, do this:

=IF(Time@row > 20, 10, (Time@row - 10))

C3:

=IF(Time@row > 30, 10, (Time@row - 20))

Etc, etc.

I think this will work. Logically in my head it makes sense that it should.

Hope this helps!