CherryxDarling
New Member
- Joined
- Mar 30, 2011
- Messages
- 39
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!!![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
=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!!