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

Learn more

View all

Sign in to view all badges

Live Cycle: Cell Limits on Return Value

Level 1
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