ISERROR and ROUNDUP

[Sparky]

Hi

Hopefully someone can help me out..

I have a cell which uses the formula

=ROUNDUP((C28/C32),0

But of course if 'C28' OR 'C32' is 0 (a zero) I get the #DIV/0! erro

My problem is that I dont want the error to show up

Now I know I can use the formula:

IF(ISERROR((C28/C32),"-",C28/C32

and the error will be replaced with a Hyphe

My question is..... How do I combine the 2 formulas. ie. I want the cell to be rounded up BUT also want to replace any errors with a hyphen

Your help is appreaciate

Cheer

Spark

 

[Dave Peterson]

=if(iserror(c28/c32),"-",roundup(c28/c32,0))

is one way.

 

[Sparky]

Gee

Thanks, dont know how I missed it, cause I thought I had tried every combination.

Thanks for your hel

Sparky

 

[Aladin Akyurek]

Also...

=IF(C32,ROUNDUP(C28/C32,0),"-")

=IF(N(C32),ROUNDUP(C28/C32,0),"-")

Hi

Hopefully someone can help me out...

I have a cell which uses the formula

=ROUNDUP((C28/C32),0)

But of course if 'C28' OR 'C32' is 0 (a zero) I get the #DIV/0! error

My problem is that I dont want the error to show up.

Now I know I can use the formula:-

IF(ISERROR((C28/C32),"-",C28/C32)

and the error will be replaced with a Hyphen

My question is..... How do I combine the 2 formulas. ie. I want the cell

to be rounded up BUT also want to replace any errors with a hyphen.