Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas Not Calculating Correctly
In a new worksheet into which I have copied formulas & number formats from
previous worksheets, the formulas in the new worksheet are not working correctly. The formulas are for subtraction in one and conversions in the other column. How can this be fixed? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas Not Calculating Correctly
What does:
previous worksheets, the formulas in the new worksheet are not working correctly. mean? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... In a new worksheet into which I have copied formulas & number formats from previous worksheets, the formulas in the new worksheet are not working correctly. The formulas are for subtraction in one and conversions in the other column. How can this be fixed? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas Not Calculating Correctly
Please don't post the same message in multiple newsgroups - it just
tends to fragment your answers, and potentially wastes the time of those replying to questions that have already been answered. FWIW, you got essentially the same reply in this group and in m.p.excel.misc. In article , Daren wrote: In a new worksheet into which I have copied formulas & number formats from previous worksheets, the formulas in the new worksheet are not working correctly. The formulas are for subtraction in one and conversions in the other column. How can this be fixed? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas Not Calculating Correctly
Here is more information...The data are times. For example, cell A1 is 9:00
and cell B1 is 12:00. Cell C1 contains the formula B1-A1, and this is where the calcuation is not right...instead of returning 3 hours, it would return something like 1 hour. Also, cell D1 is a convert function for converting hours to minutes, and the formula is =convert(c1,"hr","mn). Therefore, the subtraction and convert formulas are not working for this worksheet, even though they do work properly for other worksheets in the file. Thanks. "Sandy Mann" wrote: What does: previous worksheets, the formulas in the new worksheet are not working correctly. mean? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... In a new worksheet into which I have copied formulas & number formats from previous worksheets, the formulas in the new worksheet are not working correctly. The formulas are for subtraction in one and conversions in the other column. How can this be fixed? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas Not Calculating Correctly
Yes
"Sandy Mann" wrote: Do the copied A1 & B1 cell in the new sheet contain 9:00 & 12:00? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... Here is more information...The data are times. For example, cell A1 is 9:00 and cell B1 is 12:00. Cell C1 contains the formula B1-A1, and this is where the calcuation is not right...instead of returning 3 hours, it would return something like 1 hour. Also, cell D1 is a convert function for converting hours to minutes, and the formula is =convert(c1,"hr","mn). Therefore, the subtraction and convert formulas are not working for this worksheet, even though they do work properly for other worksheets in the file. Thanks. "Sandy Mann" wrote: What does: previous worksheets, the formulas in the new worksheet are not working correctly. mean? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... In a new worksheet into which I have copied formulas & number formats from previous worksheets, the formulas in the new worksheet are not working correctly. The formulas are for subtraction in one and conversions in the other column. How can this be fixed? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas Not Calculating Correctly
If the formulas are copied to any other sheet in the workbook and work
correctly there then I can only think that is is some sort of corruption in that sheet. Sorry I am out of guesses. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... Yes "Sandy Mann" wrote: Do the copied A1 & B1 cell in the new sheet contain 9:00 & 12:00? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... Here is more information...The data are times. For example, cell A1 is 9:00 and cell B1 is 12:00. Cell C1 contains the formula B1-A1, and this is where the calcuation is not right...instead of returning 3 hours, it would return something like 1 hour. Also, cell D1 is a convert function for converting hours to minutes, and the formula is =convert(c1,"hr","mn). Therefore, the subtraction and convert formulas are not working for this worksheet, even though they do work properly for other worksheets in the file. Thanks. "Sandy Mann" wrote: What does: previous worksheets, the formulas in the new worksheet are not working correctly. mean? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... In a new worksheet into which I have copied formulas & number formats from previous worksheets, the formulas in the new worksheet are not working correctly. The formulas are for subtraction in one and conversions in the other column. How can this be fixed? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas Not Calculating Correctly
On second thoughts you may if you wish send me a copy of the workbook and I
will take a look at it but I make no promises. Change my address as it says below in my signature. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Sandy Mann" wrote in message ... If the formulas are copied to any other sheet in the workbook and work correctly there then I can only think that is is some sort of corruption in that sheet. Sorry I am out of guesses. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... Yes "Sandy Mann" wrote: Do the copied A1 & B1 cell in the new sheet contain 9:00 & 12:00? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... Here is more information...The data are times. For example, cell A1 is 9:00 and cell B1 is 12:00. Cell C1 contains the formula B1-A1, and this is where the calcuation is not right...instead of returning 3 hours, it would return something like 1 hour. Also, cell D1 is a convert function for converting hours to minutes, and the formula is =convert(c1,"hr","mn). Therefore, the subtraction and convert formulas are not working for this worksheet, even though they do work properly for other worksheets in the file. Thanks. "Sandy Mann" wrote: What does: previous worksheets, the formulas in the new worksheet are not working correctly. mean? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... In a new worksheet into which I have copied formulas & number formats from previous worksheets, the formulas in the new worksheet are not working correctly. The formulas are for subtraction in one and conversions in the other column. How can this be fixed? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas Not Calculating Correctly
It's ok. I was able to solve the issue.
Thanks. "Sandy Mann" wrote: On second thoughts you may if you wish send me a copy of the workbook and I will take a look at it but I make no promises. Change my address as it says below in my signature. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Sandy Mann" wrote in message ... If the formulas are copied to any other sheet in the workbook and work correctly there then I can only think that is is some sort of corruption in that sheet. Sorry I am out of guesses. -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... Yes "Sandy Mann" wrote: Do the copied A1 & B1 cell in the new sheet contain 9:00 & 12:00? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... Here is more information...The data are times. For example, cell A1 is 9:00 and cell B1 is 12:00. Cell C1 contains the formula B1-A1, and this is where the calcuation is not right...instead of returning 3 hours, it would return something like 1 hour. Also, cell D1 is a convert function for converting hours to minutes, and the formula is =convert(c1,"hr","mn). Therefore, the subtraction and convert formulas are not working for this worksheet, even though they do work properly for other worksheets in the file. Thanks. "Sandy Mann" wrote: What does: previous worksheets, the formulas in the new worksheet are not working correctly. mean? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Daren" wrote in message ... In a new worksheet into which I have copied formulas & number formats from previous worksheets, the formulas in the new worksheet are not working correctly. The formulas are for subtraction in one and conversions in the other column. How can this be fixed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas Not Calculating Correctly | Excel Discussion (Misc queries) | |||
formula not calculating correctly | Excel Discussion (Misc queries) | |||
PRODUCT RESULTS/VALUE ARE NOT CALCULATING CORRECTLY | Excel Worksheet Functions | |||
why isn't this formula calculating correctly? | Excel Discussion (Misc queries) | |||
Formulas not calculating correctly | Excel Discussion (Misc queries) |