Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank column condition
Office 2k
Spreadsheet is for our local historical society bank account. Column c="expenses", e="deposits" and g="running balance". The first g column(g-3) is a carryover from previous year. What was done in past was the formula G11-C12+E12, etc.,etc. was in all cells in column G. Problem was the total was carried all the way down the sheet which looks bad. One sheet per year with ~ 65 entries. Don't write that many checks or have many deposits. :) What I'm trying to do is have the running balance columns blank unless something is in either expense or deposit column. Then it should add/subract value from cell above. Here's example of what I'm trying to do but this formula isn't working correctly. It's leaving a #VALUE! in the cell. =IF(C12="",IF(E12-"",G11-C12+E12)) Suggestions please, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank column condition
You could try something like:
=IF(AND(C12="",E12=""),"",G11-C12+E12) HTH Elkar "L.S." wrote: Office 2k Spreadsheet is for our local historical society bank account. Column c="expenses", e="deposits" and g="running balance". The first g column(g-3) is a carryover from previous year. What was done in past was the formula G11-C12+E12, etc.,etc. was in all cells in column G. Problem was the total was carried all the way down the sheet which looks bad. One sheet per year with ~ 65 entries. Don't write that many checks or have many deposits. :) What I'm trying to do is have the running balance columns blank unless something is in either expense or deposit column. Then it should add/subract value from cell above. Here's example of what I'm trying to do but this formula isn't working correctly. It's leaving a #VALUE! in the cell. =IF(C12="",IF(E12-"",G11-C12+E12)) Suggestions please, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank column condition
That did it, thanks.
Any idea what I was doing wrong or why mine didn't work? I couldn't find anything in help with your way of doing it. "Elkar" wrote in message ... You could try something like: =IF(AND(C12="",E12=""),"",G11-C12+E12) HTH Elkar "L.S." wrote: Office 2k Spreadsheet is for our local historical society bank account. Column c="expenses", e="deposits" and g="running balance". The first g column(g-3) is a carryover from previous year. What was done in past was the formula G11-C12+E12, etc.,etc. was in all cells in column G. Problem was the total was carried all the way down the sheet which looks bad. One sheet per year with ~ 65 entries. Don't write that many checks or have many deposits. :) What I'm trying to do is have the running balance columns blank unless something is in either expense or deposit column. Then it should add/subract value from cell above. Here's example of what I'm trying to do but this formula isn't working correctly. It's leaving a #VALUE! in the cell. =IF(C12="",IF(E12-"",G11-C12+E12)) Suggestions please, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank column condition
Yours didn't work because you have a minus sign after E12; it should be an
equal sign. Also, you don't specify what to do when the condition is False. Regards, Fred. "L.S." wrote in message ... That did it, thanks. Any idea what I was doing wrong or why mine didn't work? I couldn't find anything in help with your way of doing it. "Elkar" wrote in message ... You could try something like: =IF(AND(C12="",E12=""),"",G11-C12+E12) HTH Elkar "L.S." wrote: Office 2k Spreadsheet is for our local historical society bank account. Column c="expenses", e="deposits" and g="running balance". The first g column(g-3) is a carryover from previous year. What was done in past was the formula G11-C12+E12, etc.,etc. was in all cells in column G. Problem was the total was carried all the way down the sheet which looks bad. One sheet per year with ~ 65 entries. Don't write that many checks or have many deposits. :) What I'm trying to do is have the running balance columns blank unless something is in either expense or deposit column. Then it should add/subract value from cell above. Here's example of what I'm trying to do but this formula isn't working correctly. It's leaving a #VALUE! in the cell. =IF(C12="",IF(E12-"",G11-C12+E12)) Suggestions please, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank column condition
Thanks, missed the "-" sign and will work on the fomula.
Like the way Elkar did it but trying to learn. "Fred Smith" wrote in message ... Yours didn't work because you have a minus sign after E12; it should be an equal sign. Also, you don't specify what to do when the condition is False. Regards, Fred. "L.S." wrote in message ... That did it, thanks. Any idea what I was doing wrong or why mine didn't work? I couldn't find anything in help with your way of doing it. "Elkar" wrote in message ... You could try something like: =IF(AND(C12="",E12=""),"",G11-C12+E12) HTH Elkar "L.S." wrote: Office 2k Spreadsheet is for our local historical society bank account. Column c="expenses", e="deposits" and g="running balance". The first g column(g-3) is a carryover from previous year. What was done in past was the formula G11-C12+E12, etc.,etc. was in all cells in column G. Problem was the total was carried all the way down the sheet which looks bad. One sheet per year with ~ 65 entries. Don't write that many checks or have many deposits. :) What I'm trying to do is have the running balance columns blank unless something is in either expense or deposit column. Then it should add/subract value from cell above. Here's example of what I'm trying to do but this formula isn't working correctly. It's leaving a #VALUE! in the cell. =IF(C12="",IF(E12-"",G11-C12+E12)) Suggestions please, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting entries in column based on condition in another column | Excel Worksheet Functions | |||
adding numbers from column B, while condition on column A | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Keep cell blank if condition is false in IF function | Excel Discussion (Misc queries) |