J
Johnmelad502
I have this, =IF(G8=0, "", F8/G8) so that I don't get #DIV/0! when boxes are blank. But I need the answer to round up to the next whole number ie 1.4 should show as 2. Suggestions please.
Sponsored Links
=IF(G8=0,"", ROUNDUP(F8/G8,0))
or this will leave a blank if either cell is empty:
=IF(OR(G8=0,F8=0),"", ROUNDUP(F8/G8,0))
As cortina said, error traps are also worth looking into (ISERROR is only one of them).
For a fantastic resource in Excel help see here:
http://www.mrexcel.com/forum/index.php
Thousands of questions answered, although the search facility is, as a result tricky to use effectively.
or here:
http://www.ozgrid.com/Excel/
or this will leave a blank if either cell is empty:
=IF(OR(G8=0,F8=0),"", ROUNDUP(F8/G8,0))
As cortina said, error traps are also worth looking into (ISERROR is only one of them).
For a fantastic resource in Excel help see here:
http://www.mrexcel.com/forum/index.php
Thousands of questions answered, although the search facility is, as a result tricky to use effectively.
or here:
http://www.ozgrid.com/Excel/
Sponsored Links
- Joined
- 24 Sep 2005
- Messages
- 6,345
- Reaction score
- 269
- Country
IF(OR(G8="",F8="",G8=0)) covers division by zero or either cell being empty... Dividing into zero will not generate an error, just the answer zero.
You may wish to consider numbers less than zero -2.5, rounding to -2.0 or -3.0 ? But then again you may not.
-p-
You may wish to consider numbers less than zero -2.5, rounding to -2.0 or -3.0 ? But then again you may not.
-p-
