Formatting or Formula??

[stumped73]

Hi all, hopefully this is a simple problem that I'm having but I'm stumped.

I'm using the formula =IF(ISERROR(C5*K5),"",C5*K5) so that if the cell is #N/A it will display nothing at in the cell. I've used a similar formula in numerous columns and it's works great but in a few columns it is not working and shows $ - instead. I've checked for conditional formatting and there is none. I changed the formula to multiply different columns and it actually works. It seems to be something with the formula, but it calculates properly.

Any thoughts?
Stumped73

 

[stumped73]

That worked!

Thank you very much. I really appreciate it.

I'm still confused as to why only certain columns need to be formatted that way but as long as that works I'm cool with it.

 

[GlennUK]

It's because your formula does actually multiply empty cells, which are taken as zero for calculation purposes, to give a zero result. Empty cells are not taken as zero during formatting ... just for info. Glad you are cool with it anyway.

 

[stumped73]

But I'm using the same formula in other columns just multiplying different columns. ie. my total cost column is the same as my total sales (qty*cost vs qty*price)

Oh well, as they say "don't sweat the small stuff"

Thanks again.