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)

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)

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)

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)

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)

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)

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)

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 -