Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use an if formula that works on a cell with column?
I am using this formula =IF(ISBLANK($C8),($E8),($E8)) and it is working on
individual cells. My issue is when refreshing the data I don't know how many cells will need to be included. Can I use a similar formula for the entire column? Thanks, Karen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use an if formula that works on a cell with column?
What is the formula supposed to do? The True and False actions are the same.
-- __________________________________ HTH Bob "KarenABS" wrote in message ... I am using this formula =IF(ISBLANK($C8),($E8),($E8)) and it is working on individual cells. My issue is when refreshing the data I don't know how many cells will need to be included. Can I use a similar formula for the entire column? Thanks, Karen |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use an if formula that works on a cell with column?
Oh - it is supposed to check to see if there is text in the column and if
that is true it copies from one column to another. (I am sorry I posted this multiple times - I kept getting an error message!) Thanks, Karen "Bob Phillips" wrote: What is the formula supposed to do? The True and False actions are the same. -- __________________________________ HTH Bob "KarenABS" wrote in message ... I am using this formula =IF(ISBLANK($C8),($E8),($E8)) and it is working on individual cells. My issue is when refreshing the data I don't know how many cells will need to be included. Can I use a similar formula for the entire column? Thanks, Karen |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use an if formula that works on a cell with column?
Hi,
You would need to put the formula in column A. Because formula do not copy and paste anything, they just return values to the cell where the formula is. Second, if you are really trying to test for text in column C then you should be using the ISTEXT(C8) function because ISBLANK tests for numbers, text, dates, anything in the cell, not just text. -- If this helps, please click the Yes button Cheers, Shane Devenshire "KarenABS" wrote: Oh - it is supposed to check to see if there is text in the column and if that is true it copies from one column to another. (I am sorry I posted this multiple times - I kept getting an error message!) Thanks, Karen "Bob Phillips" wrote: What is the formula supposed to do? The True and False actions are the same. -- __________________________________ HTH Bob "KarenABS" wrote in message ... I am using this formula =IF(ISBLANK($C8),($E8),($E8)) and it is working on individual cells. My issue is when refreshing the data I don't know how many cells will need to be included. Can I use a similar formula for the entire column? Thanks, Karen |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use an if formula that works on a cell with column?
Thanks to everyone...I had the formula in the right cell I had just wanted to
make it work for the entire column but instead I just copied the formula past where the current data is and that should work for them. "Shane Devenshire" wrote: Hi, You would need to put the formula in column A. Because formula do not copy and paste anything, they just return values to the cell where the formula is. Second, if you are really trying to test for text in column C then you should be using the ISTEXT(C8) function because ISBLANK tests for numbers, text, dates, anything in the cell, not just text. -- If this helps, please click the Yes button Cheers, Shane Devenshire "KarenABS" wrote: Oh - it is supposed to check to see if there is text in the column and if that is true it copies from one column to another. (I am sorry I posted this multiple times - I kept getting an error message!) Thanks, Karen "Bob Phillips" wrote: What is the formula supposed to do? The True and False actions are the same. -- __________________________________ HTH Bob "KarenABS" wrote in message ... I am using this formula =IF(ISBLANK($C8),($E8),($E8)) and it is working on individual cells. My issue is when refreshing the data I don't know how many cells will need to be included. Can I use a similar formula for the entire column? Thanks, Karen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alt+Enter works in the formula bar, but not in the cell | Excel Discussion (Misc queries) | |||
MATCH FORMULA WORKS, BUT NEED HAVE BLANK CELL WHER I NOW HAVE #N/A | Excel Discussion (Misc queries) | |||
Formula that works like text-to-column | Excel Worksheet Functions | |||
Formula works but formula shows in cell??? | Excel Worksheet Functions | |||
formula works when referring to one cell but not to another | New Users to Excel |