| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement
How do I get a cell to inout what is in that cell unless it is blank, if it
is blank then return what is in another cell, if both are blank then return nothing. Example: =IF('Input Form'!C29=" ",'Input Form'!C29,'Input Form'!H17) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
hi
not exactly sure if i understand you. formulas cannot "output" values. they can only return them. an if formula can look at 2 cells and if return one or the other. or leave blank. rephrase your question. Regards FSt1 "krc547" wrote: How do I get a cell to inout what is in that cell unless it is blank, if it is blank then return what is in another cell, if both are blank then return nothing. Example: =IF('Input Form'!C29=" ",'Input Form'!C29,'Input Form'!H17) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
I need to look at cell c29, if cell C29 is blank, then cell H17, if cell h17
is blank then nothing. "FSt1" wrote: hi not exactly sure if i understand you. formulas cannot "output" values. they can only return them. an if formula can look at 2 cells and if return one or the other. or leave blank. rephrase your question. Regards FSt1 "krc547" wrote: How do I get a cell to inout what is in that cell unless it is blank, if it is blank then return what is in another cell, if both are blank then return nothing. Example: =IF('Input Form'!C29=" ",'Input Form'!C29,'Input Form'!H17) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
hi
I think i understand now. try this =IF(C29<"",C29,IF(H17<"",H17,"")) regards FSt1 "krc547" wrote: I need to look at cell c29, if cell C29 is blank, then cell H17, if cell h17 is blank then nothing. "FSt1" wrote: hi not exactly sure if i understand you. formulas cannot "output" values. they can only return them. an if formula can look at 2 cells and if return one or the other. or leave blank. rephrase your question. Regards FSt1 "krc547" wrote: How do I get a cell to inout what is in that cell unless it is blank, if it is blank then return what is in another cell, if both are blank then return nothing. Example: =IF('Input Form'!C29=" ",'Input Form'!C29,'Input Form'!H17) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
Hi,
Maybe this =IF(AND(C29="",H17=""),"",H17) HTH Martin "krc547" wrote in message ... I need to look at cell c29, if cell C29 is blank, then cell H17, if cell h17 is blank then nothing. "FSt1" wrote: hi not exactly sure if i understand you. formulas cannot "output" values. they can only return them. an if formula can look at 2 cells and if return one or the other. or leave blank. rephrase your question. Regards FSt1 "krc547" wrote: How do I get a cell to inout what is in that cell unless it is blank, if it is blank then return what is in another cell, if both are blank then return nothing. Example: =IF('Input Form'!C29=" ",'Input Form'!C29,'Input Form'!H17) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
Maybe this:
=IF('Input Form'!C29="",IF('Input Form'!H7="","",'Input Form'!H17),"'Input Form'!C29") HTH, Paul -- "krc547" wrote in message ... How do I get a cell to inout what is in that cell unless it is blank, if it is blank then return what is in another cell, if both are blank then return nothing. Example: =IF('Input Form'!C29=" ",'Input Form'!C29,'Input Form'!H17) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
The formula did not work. If comes back showing the formula in the box.
"PCLIVE" wrote: Maybe this: =IF('Input Form'!C29="",IF('Input Form'!H7="","",'Input Form'!H17),"'Input Form'!C29") HTH, Paul -- "krc547" wrote in message ... How do I get a cell to inout what is in that cell unless it is blank, if it is blank then return what is in another cell, if both are blank then return nothing. Example: =IF('Input Form'!C29=" ",'Input Form'!C29,'Input Form'!H17) |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Statement
Ensure that the cell is formatted as General, then re-enter the
formula. Hope this helps. Pete On Jan 18, 11:13*pm, krc547 wrote: The formula did not work. If comes back showing the formula in the box. "PCLIVE" wrote: Maybe this: =IF('Input Form'!C29="",IF('Input Form'!H7="","",'Input Form'!H17),"'Input Form'!C29") HTH, Paul -- "krc547" wrote in message ... How do I get a cell to inout what is in that cell unless it is blank, if it is blank then return what is in *another cell, if both are blank then return nothing. Example: =IF('Input Form'!C29=" ",'Input Form'!C29,'Input Form'!H17)- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| If Statement + LEN | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
