Recalculate the IF statemtn value to a text message
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
|