how can I see 0.00% instead of #DIV/!0 in cell H214?
2 réponses
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?
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
jero
IF(ISERROR(H212/H213),0,H212/H213) or something like that... but with EXCEL and not ACCESS jpg "Fred's" a écrit dans le message de news:
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
IF(ISERROR(H212/H213),0,H212/H213) or something like that... but with EXCEL
and not ACCESS
jpg
"Fred's" <frederic10_mess@hotmail.com> a écrit dans le message de news:
c4fa21fa-0e95-4eb2-9256-46ad9ad57596@p8g2000yqb.googlegroups.com...
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?
IF(ISERROR(H212/H213),0,H212/H213) or something like that... but with EXCEL and not ACCESS jpg "Fred's" a écrit dans le message de news:
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
Selon : Bonjour ou bonsoir
IF(H213=0,0,H212/H213)
Cdt, Blaise ---- ---- ----
"Fred's" a écrit dans le message de news:
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
Selon : Bonjour ou bonsoir
IF(H213=0,0,H212/H213)
Cdt, Blaise
---- ---- ----
"Fred's" <frederic10_mess@hotmail.com> a écrit dans le message de news:
c4fa21fa-0e95-4eb2-9256-46ad9ad57596@p8g2000yqb.googlegroups.com...
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?
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?