Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Recalculate the IF statement value to a text message
I fixed it, there was some conditional formatting from another party that I
was not aware of. Thank you for the help! -- 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Recalculate the IF statemtn value to a text message
To trap for an error, you need to do it in the following fashion:
=if(iserr(formula),"",formula) Next, you need to spell the function properly. It's "networkdays", not "networkdyas". Thirdly, your parentheses must match. You have a "9" after networkdyas, rather than the required opening parenthesis. Fourth, you need to identify the worksheet properly. Sometimes you have "bldg8" (without a space), and sometimes "bldg 8" (with a space). Fix these errors, and the formula should work. Post back if you need more help. Don't expect us to continually fix typographic errors, though. -- Regards, Fred "Cham" wrote in 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Recalculate the IF statemtn value to a text message
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Recalculate the IF statemtn value to a text message
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
message box text | Excel Worksheet Functions | |||
Can you text message from Outlook? | Excel Discussion (Misc queries) | |||
Text message using data validation. | Excel Discussion (Misc queries) | |||
Text Error Message | Excel Worksheet Functions | |||
text box to contain formulae results that recalculate | Excel Discussion (Misc queries) |