Thread: If Statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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)