Problem with =H4*C4/5 formula?

[PhilipeC]

I want to calculate H4 multiplied by C4 and then divided by 5 such as =H4*C4/5 but using this simple formula, if cell H4 is in blank than #VALUE ! appears. How to solve this issue?

 

[Ron Coderre]

Try something like this:

=IFERROR(H4*C4/5,0)

Or maybe

=IFERROR(H4*C4/5,"n/a")

Does that help?

 

[PhilipeC]

It appears ´You enter to few arguments for this function´.

 

[Ron Coderre]

If you are in a region that uses semicolons instead of commas in formulas...
Try this:

=IFERROR(H4*C4/5;0)

Does that solve the problem?

 

[PhilipeC]

It worked , Thank you.

 

[joeu2004]

Alternatively:

=N(H4)*N(C4)/5

The N() function returns zero when H4 or C4 is not numeric.