I am wondering how to insert a formula into a cell which will display a blank result when the values in the cells being accessed are blank.

For example I have formula of =F4/C4*100 which displays #DIV/0! when (cells) F4 and or C4 are blank.



Thanks

Try:
=IF(C4=0,"",F4/C4*100)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks
If should have known better. I used to be an analyst/programmer and forgot about logical functions.
I note that the function VAL is not in Excel.
When a cell is blank and the cell is formatted as a number (this occurs when you initially format it as a number) how can you test if the cell contains nothing (ie blank) rather than containing the value zero - actually can you test if the cell is blank OR zero?

This will do that
=IF(ISBLANK(A1),"It's Blank","It's Not Blank")

Try...

=IF(N(C4),F4/C4*100,"")

Lovely!
Works just the way I prefer. If the input cells contain nothing (clear), or a space or zero (0) then it returns a blank (ie clear)
I have not seen that logical operator before ie N()
Please explain.
Thanks again
John

Hi John,

Glad you have something to work with and you're welcome.

Maybe this will help

http://www.excelfunctions.net/Excel-N-Function.html

Thanks heaps.

What about

=iferror(F4/C4*100,0)

?