You are viewing limited content. For full access, please sign in.

Question

Question

Round up to nearest half

Forms
Updated June 11, 2018
asked on June 10, 2018

Hi All,

Trying to find a way to to round up a value to the nearest half. 

For example, 1.1 would be rounded up to 1.5.  1.6 would be rounded up to 2

I'm using Forms 10.3.1

 

Thanks

0 0

Answer

SELECTED ANSWER
replied on June 11, 2018

=CEILING(value,0.5)

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...