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)