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)