You're missing a quote mark (or you've got a spare one). And unless you've
got a sheet called sheet2 and another sheet called sheet 2, you need to be
consistent with the spaces.
--
David Biddulph

"AT" wrote in message
...
.... I have used
the following to suppress the error msg so nothing comes up, but it fails
to
correct it.

=IF('sheet2!F4="","",'sheet 2'!F3/'sheet2'!F4)

So if cell 'sheet2!F4 is blank, then nothing is input, otherwise process
F3/F4. To me, it looks like a simple process, but Excel doesnt like it.

If someone could shine some light on this, that would be much appreciated.