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

Avatar

Avatar
Level 1
the_only_max
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
the_only_max
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
the_only_max
Level 1

27-05-2020

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

Accepted Solutions (0)

Answers (0)