Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Live Cycle: Cell Limits on Return Value


Level 1

I want cell "a" to return a value from cell "b" that is no greater than 8 and no less than 0. Example: If someone inputs 12 into cell "b" I only want "a" to show 8.

This is for a timesheet where I am splitting cell "b" to regular hours and to hours.





0 Replies