Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
Formulas Not Calculating Correctly
Pretty hard to tell since you don't say what "not working correctly"
means to you. Are you getting an error? Incorrect results? A crash? Perhaps if you replied with example(s) of your formulae, their inputs, and what you expect, it would be easier to give a definitive answer. 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas Not Calculating Correctly
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 "JE McGimpsey" wrote: Pretty hard to tell since you don't say what "not working correctly" means to you. Are you getting an error? Incorrect results? A crash? Perhaps if you replied with example(s) of your formulae, their inputs, and what you expect, it would be easier to give a definitive answer. 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.misc
|
|||
|
|||
Formulas Not Calculating Correctly
Tools/ Options/ Calculation: set it to Automatic, not Manual.
-- David Biddulph "Daren" wrote in message ... 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 "JE McGimpsey" wrote: Pretty hard to tell since you don't say what "not working correctly" means to you. Are you getting an error? Incorrect results? A crash? Perhaps if you replied with example(s) of your formulae, their inputs, and what you expect, it would be easier to give a definitive answer. 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas Not Calculating Correctly
It worked. Thanks a bunch!
"David Biddulph" wrote: Tools/ Options/ Calculation: set it to Automatic, not Manual. -- David Biddulph "Daren" wrote in message ... 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 "JE McGimpsey" wrote: Pretty hard to tell since you don't say what "not working correctly" means to you. Are you getting an error? Incorrect results? A crash? Perhaps if you replied with example(s) of your formulae, their inputs, and what you expect, it would be easier to give a definitive answer. 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
figure out why this formula isn't calculating correctly | Excel Discussion (Misc queries) | |||
Formulas not calculating correctly | Excel Discussion (Misc queries) |