Excel Formula

  • Thread starter Thread starter krc547
  • Start date Start date
K

krc547

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,
 
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
 
Try it:

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

Cheers

"krc547" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup result in a message box 10
Concatenated formula help 3
Count occurances in a range. 5
Assigning a Macro to Checkbox on a worksheet 2
Prevent User from Going Past a Certain Cell 3
Question on Logical IF statement 2
Fade text in a cell, disappeared when we input new text. 1
link change 1

Back
Top