Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I say "if this cell is blank, use this formula...
I'd like to set up a formula (function?) that says,
If this cell is blank, then use this formula. If the same cell has data, then use this forumula. But I just can't figure out how to do it. Any help would be great. I know the two formula's I want to use, I just don't know how to direct the cell to the right one. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I say "if this cell is blank, use this formula...
You can try this:
=If(Isblank(A1),formula1,formula2) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Linhob" wrote in message ... I'd like to set up a formula (function?) that says, If this cell is blank, then use this formula. If the same cell has data, then use this forumula. But I just can't figure out how to do it. Any help would be great. I know the two formula's I want to use, I just don't know how to direct the cell to the right one. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I say "if this cell is blank, use this formula...
=if(a1="",yourfirstformula,yourotherformula)
=if(a1="",average(b3:c99),sum(x9:z99)) Linhob wrote: I'd like to set up a formula (function?) that says, If this cell is blank, then use this formula. If the same cell has data, then use this forumula. But I just can't figure out how to do it. Any help would be great. I know the two formula's I want to use, I just don't know how to direct the cell to the right one. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I say "if this cell is blank, use this formula...
Try the ISBLANK() function, for example:
=IF(ISBLANK(A1),function_if_blank,function_if_non_ blank) Does that help? -- Regards, Dave "Linhob" wrote: I'd like to set up a formula (function?) that says, If this cell is blank, then use this formula. If the same cell has data, then use this forumula. But I just can't figure out how to do it. Any help would be great. I know the two formula's I want to use, I just don't know how to direct the cell to the right one. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I say "if this cell is blank, use this formula...
This is definitely helping to get me in the right direction. I understand
that I need to put the cell that I want to check whether it is blank or not. I'm not sure what to do w/ the function portion. So currently my formual looks like this =if(isblank(j22),=-e22+today()_if_blank,=j22-e22_if_non_blank) Of course this isn't translating, but it's closer to where I should be. "David Billigmeier" wrote: Try the ISBLANK() function, for example: =IF(ISBLANK(A1),function_if_blank,function_if_non_ blank) Does that help? -- Regards, Dave "Linhob" wrote: I'd like to set up a formula (function?) that says, If this cell is blank, then use this formula. If the same cell has data, then use this forumula. But I just can't figure out how to do it. Any help would be great. I know the two formula's I want to use, I just don't know how to direct the cell to the right one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
How to stop excel from plotting a "blank" cell with formula as zer | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |