Display in cell not the result of formula in cell

aitkena · Apr 29th, 2002, 12:37 AM

In my spreadsheet, the number displayed in the cell is not the result of the formula in the cell. For example, if the formula is 10 + 5, the displayed result should be 15. But the number displayed is not 15. If the cell is edited, the display changes to the result of the formula. The spreadsheet is on automatic calc. If it makes a difference, the cells were created by a macro.

Chris Davison · Apr 29th, 2002, 06:10 AM

what is displayed when 15 should be displayed ?

what is also displayed when 200 should be displayed ?

edit.... and what is the formula ?

[ This Message was edited by: Chris Davison on 2002-04-29 10:59 ]

aitkena · Apr 29th, 2002, 05:41 PM

The formula in cell c9 of tab A is: =if(current!$x9=0,"",current!c9/current!$x9). When current!c9=11,557 and current!x9=3,107,020, c9/x9=.0037196 but the number displayed in A!c9 is 2.30808. Cell c10 has the same formula copied down; when current!c10=15,879 and current!x10=2,766,635, c10/x10=.0057395 but the number displayed is 2.93708.

The cells in current! are linked to tab Historic!. If the values in Historic! are changed, the display in A! will be updated to display the result of the division. However, the cells in Historic! will not be changed when working with this spreadsheet.

Chris Davison · Apr 29th, 2002, 10:40 PM

what's the macro ?

(post the code if you can)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 12:37 AM	#1
aitkena New Member Join Date: Apr 2002 Posts: 4	In my spreadsheet, the number displayed in the cell is not the result of the formula in the cell. For example, if the formula is 10 + 5, the displayed result should be 15. But the number displayed is not 15. If the cell is edited, the display changes to the result of the formula. The spreadsheet is on automatic calc. If it makes a difference, the cells were created by a macro.

Apr 29th, 2002, 06:10 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	what is displayed when 15 should be displayed ? what is also displayed when 200 should be displayed ? edit.... and what is the formula ? [ This Message was edited by: Chris Davison on 2002-04-29 10:59 ]

Apr 29th, 2002, 05:41 PM	#3
aitkena New Member Join Date: Apr 2002 Posts: 4	The formula in cell c9 of tab A is: =if(current!$x9=0,"",current!c9/current!$x9). When current!c9=11,557 and current!x9=3,107,020, c9/x9=.0037196 but the number displayed in A!c9 is 2.30808. Cell c10 has the same formula copied down; when current!c10=15,879 and current!x10=2,766,635, c10/x10=.0057395 but the number displayed is 2.93708. The cells in current! are linked to tab Historic!. If the values in Historic! are changed, the display in A! will be updated to display the result of the division. However, the cells in Historic! will not be changed when working with this spreadsheet.

Apr 29th, 2002, 10:40 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	what's the macro ? (post the code if you can)