# IF cell ISBLANK/"", then use alternative IF function

1. ## IF cell ISBLANK/"", then use alternative IF function

Hello Everyone (first post),

Long time Excel user getting more advanced with cell logic formulas, need some help please. I'm trying to apply a logic to column 3 cell, which is dependent on logic in the column 2 cell, which will only apply if the cell in column 1 is empty, otherwise, it will populate the info from the cell in column 1 directly to the cell in column 3. My current formula looks like this:

Cell A3=IF(a1<>"",a1,(=if(a2="no","Not Required", (if(a2="yes", "Required")))))

2. ## Re: IF cell ISBLANK/"", then use alternative IF function

Untested, but try:
Formula:
`Please Login or Register  to view this content.`

3. ## Re: IF cell ISBLANK/"", then use alternative IF function

Hi and welcome to the forum

Maybe
Formula:
`Please Login or Register  to view this content.`

or because you don't have any False parameters pehaps

Formula:
`Please Login or Register  to view this content.`

4. ## Re: IF cell ISBLANK/"", then use alternative IF function

Worked thank you! Problem was in the IFFalse section/area I had too much going on including = and an extra ().

5. ## Re: IF cell ISBLANK/"", then use alternative IF function

You're welcome. Thanks for the rep.

New quick method:

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

6. ## Re: IF cell ISBLANK/"", then use alternative IF function

=IF(A1<>"",A1,IF(A2="no","Not Required",(IF(A2="yes","Required",""))))

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1