Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel fill failure
I have Windows Vista Home Basic running Office Standard 2007
This is my homemade checking account. The balance formula is I153-G154+H154, where I153 is the previous balance, G154 is a new debit and H154 is a new credit. Normally when I fill the resulting balance further down column I, it shows the balance repeated. This has been working fine from the start months ago. Today it repeated the resulting balance in the next row, 155, yielded by the filled formula I154-G155+H155, the latter two being empty cells as always. Thereafter, rows 156 and following, the correct filled formula is repeated in column I, but a #VALUE error is returned instead of the repreated previous balance. The error message is: "A value in the formula is of the wrong data type." I156 and downward adds a green triangle in the upper left cell corner. This does not appear in the cells above it. My eMachine would neither restart not shut down programmatically. I had to power down manually. Rebooting normally did not solve the problem. What's going on? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel fill failure
Perhaps you have spaces in those cells G156:H156 and down, and you
can't perform arithmetic on them. Just highlight the cells and press the <delete key to remove them. You might like to change your formula to: =IF(AND(G154="",H154=""),"",I153-G154+H154) and copy this down - it will give you a blank cell if both the G and H cells are empty, i.e. until you enter some data. Hope this helps. Pete On Nov 10, 11:57 pm, johnthebaptist wrote: I have Windows Vista Home Basic running Office Standard 2007 This is my homemade checking account. The balance formula is I153-G154+H154, where I153 is the previous balance, G154 is a new debit and H154 is a new credit. Normally when I fill the resulting balance further down column I, it shows the balance repeated. This has been working fine from the start months ago. Today it repeated the resulting balance in the next row, 155, yielded by the filled formula I154-G155+H155, the latter two being empty cells as always. Thereafter, rows 156 and following, the correct filled formula is repeated in column I, but a #VALUE error is returned instead of the repreated previous balance. The error message is: "A value in the formula is of the wrong data type." I156 and downward adds a green triangle in the upper left cell corner. This does not appear in the cells above it. My eMachine would neither restart not shut down programmatically. I had to power down manually. Rebooting normally did not solve the problem. What's going on? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel fill failure
Your <delete solution solved the problem, Pete_UK. Very much obliged. And
the space must have been unwittingly entered in H155, because selecting and deleting just in the G column did not work. To check, I reentered a space in H155, and sure enough, the mystery data popped up in the I column. "Pete_UK" wrote: Perhaps you have spaces in those cells G156:H156 and down, and you can't perform arithmetic on them. Just highlight the cells and press the <delete key to remove them. You might like to change your formula to: =IF(AND(G154="",H154=""),"",I153-G154+H154) and copy this down - it will give you a blank cell if both the G and H cells are empty, i.e. until you enter some data. Hope this helps. Pete On Nov 10, 11:57 pm, johnthebaptist wrote: I have Windows Vista Home Basic running Office Standard 2007 This is my homemade checking account. The balance formula is I153-G154+H154, where I153 is the previous balance, G154 is a new debit and H154 is a new credit. Normally when I fill the resulting balance further down column I, it shows the balance repeated. This has been working fine from the start months ago. Today it repeated the resulting balance in the next row, 155, yielded by the filled formula I154-G155+H155, the latter two being empty cells as always. Thereafter, rows 156 and following, the correct filled formula is repeated in column I, but a #VALUE error is returned instead of the repreated previous balance. The error message is: "A value in the formula is of the wrong data type." I156 and downward adds a green triangle in the upper left cell corner. This does not appear in the cells above it. My eMachine would neither restart not shut down programmatically. I had to power down manually. Rebooting normally did not solve the problem. What's going on? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel.exe failure when copy & paste | Excel Discussion (Misc queries) | |||
E-Mail Attachment Failure - Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2003 update failure | New Users to Excel | |||
Howeractivate Excel after a macro failure | Excel Worksheet Functions | |||
Excel 2003 Link failure | Links and Linking in Excel |