Software

Ask something
Question Locked

MS Excel If Function together Roundup & Down

0 helpful
2 replies

by sanjeevti

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a problem I want to use ROUNDUP & ROUNDDOWN Function together with if Function. As if(Cell value >0.49 =ROUNDUP((Cell value*10*0.01),0) else ROUNDDOWN((Cell value*10*0.01),0)

NOTE : where Cell value = (A14*10%)

So what can I do this, Plz send me a Complete hint.

2 replies

by bizzo

Or I may be a bit confused with your "cell value", if you want to use roundup and rounddown within an if statement, do it like this:

=IF(A1>0.49,ROUNDUP(A1,0),ROUNDDOWN(A1,0))

This discussion is closed to new replies.