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 -