how can I see 0.00% instead of #DIV/!0 in cell H214?

Le
Fred's
Hi,

I hope that someone can help me out with my problem.

in cell H212 I have $37,000
in cell H213 I have $35,000
in cell H214 I have the difference in %, this mean
$37,000-$35,000/$35,000 which give me the result -0.54%

But if one or both of these cells H212, H213 are empty it give me the
result #DIV/!0 in cell H214

So, how can I see 0.00% instead of #DIV/!0 in cell H214?

Thanking you in advance for your help!!
Fred's
Vidéos High-Tech et Jeu Vidéo
Téléchargements
Vos réponses
Gagnez chaque mois un abonnement Premium avec GNT : Inscrivez-vous !
Trier par : date / pertinence
jero
Le #20733671
IF(ISERROR(H212/H213),0,H212/H213) or something like that... but with EXCEL
and not ACCESS
jpg
"Fred's"
Hi,

I hope that someone can help me out with my problem.

in cell H212 I have $37,000
in cell H213 I have $35,000
in cell H214 I have the difference in %, this mean
$37,000-$35,000/$35,000 which give me the result -0.54%

But if one or both of these cells H212, H213 are empty it give me the
result #DIV/!0 in cell H214

So, how can I see 0.00% instead of #DIV/!0 in cell H214?

Thanking you in advance for your help!!
Fred's


Blaise Cacramp
Le #20747421
Selon : Bonjour ou bonsoir

IF(H213=0,0,H212/H213)


Cdt, Blaise
---- ---- ----


"Fred's"
Hi,

I hope that someone can help me out with my problem.

in cell H212 I have $37,000
in cell H213 I have $35,000
in cell H214 I have the difference in %, this mean
$37,000-$35,000/$35,000 which give me the result -0.54%

But if one or both of these cells H212, H213 are empty it give me the
result #DIV/!0 in cell H214

So, how can I see 0.00% instead of #DIV/!0 in cell H214?

Thanking you in advance for your help!!
Fred's


Publicité
Poster une réponse
Anonyme