i tried it but, the end valua came back blank...
--
Cham


"Toppers" wrote:

General format:

=IF(ISERROR(formula),"Error message",formula)

=IF('BLDG8'A62='BLDG 7'!A62,IF(ISERROR(networkdays('BLDG 8'!c62,'bLDG
7'!c62)),"Your error text",networkdays('BLDG 8'!c62,'bLDG 7'!c62)))

HTH

"Cham" wrote:

Hi,
I have a formula like this:


IF(IF('BLDG8'A62='BLDG 7'!A62,networkdyas9'BLDG 8'!c62,'bLDG 7'!c62),
"")=ISERR('Bldg 8'!d74), 'Bldg 8'!74,"")

the first If function returns a "#Value", my attemp on the above function is
to get a text value answer if the formula comesa out as #VAlue. I .e. the
IF('BLDG8'A62='BLDG 7'!A62,networkdyas9'BLDG 8'!c62,'bLDG 7'!c62)=
#Value,(which is an error), then give the Sheet X Cellx Value as a end value.
the sheet X value is a written statement.

Any suggestions on how to do this? or even improve the IF statement. Because
not all cells will have a text input, tmajority have dates.


--
Cham