Posted to microsoft.public.excel.worksheet.functions
|
|
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????
|