IF Function and ROUNDUP help

[CherryxDarling]

I'm trying to use the IF function with the ROUNDUP function and I am having no luck. Basically what I'm trying to do is this:

=IF(E7>=125,((E7/2)/125),(""))

If the value in E7 is greater than or equal to 125, then I want to divide it by 2 and divide that value by 125. Then after that calculation I want to round the final answer up, regardless of the decimal.

I have no idea where to put the ROUNDUP function. I've tried 20 different possibilities and all I get is an error. Please help!

NOTE: I was successful in doing it in another cell when I used this formula:

=ROUNDUP(IF(L7>=500,(L7/500),(" ")),0)

The only differences was that I'm only dividing L7 once by 500. I'm so confused!!

 

[mattd4385]

One way: In the Home Tab and number section you can moce the dec (.) to rounds

 

[JackDanIce]

Welcome to the board.

Firstly, if you divide by 2 and then by 125, why don't you just divide by 250?

Try this:

=IF(E7<125,"",ROUNDUP(E7/250,0))

 

[VoG]

Try

=IF(E7>=125,ROUNDUP((E7/2)/125,0),"")

 

[CherryxDarling]

Thank you so much this is exactly what I was looking for! I can't believe how fast I got a reply. You have no idea how happy I am right now!!

 

[CherryxDarling]

Welcome to the board.

Firstly, if you divide by 2 and then by 125, why don't you just divide by 250?

Try this:

=IF(E7<125,"",ROUNDUP(E7/250,0))

That would make sense, however I'm using this formula with multiple values. In other words, I won't always be dividing by 125.

 

[CherryxDarling]

One way: In the Home Tab and number section you can moce the dec (.) to rounds

I don't think that would always round it up though, right?