I am having a brain fade, How do I get an if statement to look at a cell and
if there is anything in that cell, then that cell otherwise a different cell?
Below is what I have
=IF('Input Form'!C32=" ",'Input Form'!C32,'Input Form'!H17)

Looks like you are trying to do it backwards, you are saying if it is blank,
put the data in there(which keeps it blank), you need to do that when it is
not blank
from this
IF('Input Form'!C32=" ",'Input Form'!C32,
to this
IF('Input Form'!C32<" ",'Input Form'!C32,

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"krc547" wrote:

I am having a brain fade, How do I get an if statement to look at a cell and
if there is anything in that cell, then that cell otherwise a different cell?
Below is what I have
=IF('Input Form'!C32=" ",'Input Form'!C32,'Input Form'!H17)

hi
i think your logic is backwards. try this
=IF('Input Form'!C32=" ",'Input Form'!H17,'Input Form'!C32)

bring back h17 if c32 is empty else c32 if c32 is not empty.

Regards
FSt1

"krc547" wrote:

I am having a brain fade, How do I get an if statement to look at a cell and
if there is anything in that cell, then that cell otherwise a different cell?
Below is what I have
=IF('Input Form'!C32=" ",'Input Form'!C32,'Input Form'!H17)

Try it:

=IF('Input Form'!C32="";'Input Form'!C32;'Input Form'!H17)

Cheers

"krc547" escreveu:

I am having a brain fade, How do I get an if statement to look at a cell and
if there is anything in that cell, then that cell otherwise a different cell?
Below is what I have
=IF('Input Form'!C32=" ",'Input Form'!C32,'Input Form'!H17)