rounding
 

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

rounding
 

=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

rounding
 

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

rounding
 

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

rounding
 

"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

rounding
 

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

rounding
 

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

rounding
 

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