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

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

--

HTH

Bob Phillips

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

"egarcia" wrote in message
...
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

Maybe this?:

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


Is that something you can work with?

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

XL2002, WinXP


"egarcia" wrote:

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

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.

"Ron Coderre" wrote:

Maybe this?:

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


Is that something you can work with?

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

XL2002, WinXP


"egarcia" wrote:

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

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

"egarcia" wrote:

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.

"Ron Coderre" wrote:

Maybe this?:

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


Is that something you can work with?

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

XL2002, WinXP


"egarcia" wrote:

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

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/AB360,max(1,ROUND(CEILING(AB23/AB36,0.4999),0)),0)


"egarcia" wrote:

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.

"Ron Coderre" wrote:

Maybe this?:

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


Is that something you can work with?

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

XL2002, WinXP


"egarcia" wrote:

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

Try this:

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


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

XL2002, WinXP


"egarcia" wrote:

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.

"Ron Coderre" wrote:

Maybe this?:

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


Is that something you can work with?

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

XL2002, WinXP


"egarcia" wrote:

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

"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

"egarcia" wrote:

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