remove div/0 values in excel cells

A

ash

Hello Members,
I have a problem with Excel ,currently working with Cells .Where I want
to remove Div/0 value from excel cell.

Help me please,Its a production problem...

Thanks In Advance


Ash
 
N

Niek Otten

Hi Ash,

=A1/B1; replace with =IF(B1=0,"",A1/B1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello Members,
| I have a problem with Excel ,currently working with Cells .Where I want
| to remove Div/0 value from excel cell.
|
| Help me please,Its a production problem...
|
| Thanks In Advance
|
|
| Ash
|
 
Top