ISERROR and ROUNDUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Gee

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

Thanks for your hel

Sparky
 
Also...

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

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

Sparky said:
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
Click to expand...
to be rounded up BUT also want to replace any errors with a hyphen.
 
Back
Top