Software

Question

Gravatar
Locked

MS Excel If Function together Roundup & Down

By sanjeevti ·
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.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

Not sure where the problem is

by Bizzo In reply to MS Excel If Function toge ...

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))

Back to Software Forum
1 total post (Page 1 of 1)  

Start or search

Related Discussions

Related Forums