rounding

[Guest]

I'm trying to round resources down if they are less than .5, up if greater
than a .5, and also equal to 1 if less than .5. For example 1.2 = 1, & 1.6 =
2, .4 = 1. My formula is = round(AB23/AB36,0), but less than .5 = 0

 

[Bob Phillips]

=MAX(1,ROUND(AB23/AB36,0))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

Maybe this?:

=MAX(1,ROUND(AB23/AB36,0))


Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

My zeros are returning as 1 and i have too many resources. I want zeros to
return as zeros, and any value to return with at least one.

 

[Guest]

"round resources down" :
<<<My formula is = round(AB23/AB36,0), but less than .5 = 0>>>

i assume u need a whole number result :
i assume a Non-negative result of AB23/AB36 "resources"

=+IF(AB23/AB36>=0.5,ROUND(CEILING(AB23/AB36,0.4999),0),0)

happy holidays

 

[Guest]

from your first need you write
" but less than .5 = 0"
is this change already? 0.4<0.5 then 0.

 

[Guest]

i am confused again, i am poor in reading english, sorry....

if AB23/AB36=0.1, and you like result as 1.
maybe this is possible.
=+IF(AB23/AB36>0,max(1,ROUND(CEILING(AB23/AB36,0.4999),0)),0)

 

[Guest]

Try this:

=MAX(1,ROUND(AB23/AB36,0))*(AB23>0)


Does that help?
***********
Regards,
Ron

XL2002, WinXP