How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi
 

I am trying to have the "ROUNDOWN" function as my true, and "ROUNDUP"as my
false... See my current incorrect formula below.... HELP

=IF(I35/I211,ROUNDDOWN((I35/(I21+(I21+1)/2),0),(ROUNDUP(I35/I21),0)


why wont this work????

How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi
 

Hi,

Your parenthesis were incorrect

=IF(I35/I211,ROUNDDOWN(I35/(I21+(I21+1)/2),0),(ROUNDUP(I35/I21,0)))

Mike

"EXCEL IN NEED" wrote:

I am trying to have the "ROUNDOWN" function as my true, and "ROUNDUP"as my
false... See my current incorrect formula below.... HELP

=IF(I35/I211,ROUNDDOWN((I35/(I21+(I21+1)/2),0),(ROUNDUP(I35/I21),0)


why wont this work????

How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi
 

Hi

It's a paranthesis problem, try this:

=IF(I35/I211,ROUNDDOWN((I35/(I21+(I21+1)/2)),0),ROUNDUP(I35/I21,0))


Regards,
Per

"EXCEL IN NEED" <EXCEL IN skrev i
meddelelsen ...
I am trying to have the "ROUNDOWN" function as my true, and "ROUNDUP"as my
false... See my current incorrect formula below.... HELP

=IF(I35/I211,ROUNDDOWN((I35/(I21+(I21+1)/2),0),(ROUNDUP(I35/I21),0)


why wont this work????

How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi
 

Hi,

And while you are fixing the parenthesis problem we could also simplify it to:

=IF(I35/I211,ROUNDDOWN(I35/(1.5*I21+0.5),),ROUNDUP(I35/I21,))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"EXCEL IN NEED" wrote:

I am trying to have the "ROUNDOWN" function as my true, and "ROUNDUP"as my
false... See my current incorrect formula below.... HELP

=IF(I35/I211,ROUNDDOWN((I35/(I21+(I21+1)/2),0),(ROUNDUP(I35/I21),0)


why wont this work????