Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message #NAME from formula
I have a the formula "YEARFRAC" on one of my spreadsheets to calculate the
length of time between two dates. When I look at the spreadsheet on my computer, the formula displays the correct answer, and also does so on most of my co-workers computers. However, for on co-worker, she gets the error "#NAME." I think it is a setting on her computer, but cannot find one. Any ideas, or am I missing the setting? Thanks! Josh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message #NAME from formula
"JDub" wrote in message
... I have a the formula "YEARFRAC" on one of my spreadsheets to calculate the length of time between two dates. When I look at the spreadsheet on my computer, the formula displays the correct answer, and also does so on most of my co-workers computers. However, for on co-worker, she gets the error "#NAME." I think it is a setting on her computer, but cannot find one. Any ideas, or am I missing the setting? Analysis ToolPak: http://office.microsoft.com/en-gb/as...093441033.aspx -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message #NAME from formula
Another way would be to use your Excel help looking up YEARFRAC
whether in HELP or on the referred to web page (they are the same content), you should expand the presentation with the "Show All" link in the upper right of the help page. "David Biddulph" wrote in message ... "JDub" wrote in message ... I have a the formula "YEARFRAC" on one of my spreadsheets to calculate the length of time between two dates. When I look at the spreadsheet on my computer, the formula displays the correct answer, and also does so on most of my co-workers computers. However, for on co-worker, she gets the error "#NAME." I think it is a setting on her computer, but cannot find one. Any ideas, or am I missing the setting? Analysis ToolPak: http://office.microsoft.com/en-gb/as...093441033.aspx -- David Biddulph |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message #NAME from formula
Many thanks!
"David McRitchie" wrote: Another way would be to use your Excel help looking up YEARFRAC whether in HELP or on the referred to web page (they are the same content), you should expand the presentation with the "Show All" link in the upper right of the help page. "David Biddulph" wrote in message ... "JDub" wrote in message ... I have a the formula "YEARFRAC" on one of my spreadsheets to calculate the length of time between two dates. When I look at the spreadsheet on my computer, the formula displays the correct answer, and also does so on most of my co-workers computers. However, for on co-worker, she gets the error "#NAME." I think it is a setting on her computer, but cannot find one. Any ideas, or am I missing the setting? Analysis ToolPak: http://office.microsoft.com/en-gb/as...093441033.aspx -- David Biddulph |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error message #NAME from formula
Many thanks!
"David Biddulph" wrote: "JDub" wrote in message ... I have a the formula "YEARFRAC" on one of my spreadsheets to calculate the length of time between two dates. When I look at the spreadsheet on my computer, the formula displays the correct answer, and also does so on most of my co-workers computers. However, for on co-worker, she gets the error "#NAME." I think it is a setting on her computer, but cannot find one. Any ideas, or am I missing the setting? Analysis ToolPak: http://office.microsoft.com/en-gb/as...093441033.aspx -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |