Thread: How can I use the ROUNDOWN and ROUNDUP functions in an "IF" functi
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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????
Reply With QuoteReply With Quote