ERROR.TYPE
http://office.microsoft.com/en-us/ex...090791033.aspx
--
David Biddulph

"Victor Delta" wrote in message
...
I have a formula in a spreadsheet with several nested if statements.

Even when some of the statements should be false, a #VALUE! error earlier
on is mucking up the logical outputs.

Is there a simple way to 'isolate' such an error code so that it does not
affect subsequent logical outputs please?

Thanks,

V