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
BedrockMission!

Learn more

View all

Sign in to view all badges

Live Cycle: Cell Limits on Return Value

the_only_max
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.

 

 

Thanks,

Max

0 Replies