# Populate same Cell with 2 possible out comes with If(isblank)

1. ## Populate same Cell with 2 possible out comes with If(isblank)

Hi,
I am trying to populate a cell (R3) with 2 possible out comes, although I can't work out how to do it. Both formulas are below and are required in cell (R3). Basically if (T3) is populated with a date (R3) returns a completed statement, but I also require (R3) to return a blank cell if (S3) is not populated with a date.

=IF(ISBLANK(\$T3),\$S3+365,"Completed")
=IF(ISBLANK(\$S3),"",\$S3+365)

Any help would be appreciated.

Kevin.

2. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

Welcome to the forum.

Makes no sense! If S3 is blank, you want to add 365 to S3??? How when there's nothing there???

Try again ...

3. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

So only if there are dates in both S&T you want R to return "complete", and in other scenarios R will remain blank?

try this:
=IF(AND(ISNUMBER(T3),(ISNUMBER(S3))),"completed","")

4. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

Hi AliGW,
Thanks for looking at this, but I require the Eye sight due box (R3) to either display complete if there as been a test taken in (T3) or to display nothing if the last eye sight test (S3) as not been yet been populated. At the moment I can do one or the other but not both in the same cell. I have tried to simplify it by keeping it on one sheet but there are sheets for say next year and of course the eye sight test hasn't been done yet!

Hope that explains it better!
Once again thank you,
Kevin.

5. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

OK.

What happens if:

Both S3 and T3 are blank?
Both S3 and T3are populated?

Which needs checking first?

What happens if none of the criteria are met?

6. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

If both S3 and T3 are blank then R3 is displaying 30/12/1900 with the formula =IF(ISBLANK(\$T3),\$S3+365,"Complete")
If both S3 and T3 are populated R3 is displaying Complete with the same formula

The last eye sight test (S3) will require checking first.

If none of the criteria are met then then it's just the same if S3 and T3 are blank R3 auto populates the formula with a figure of 30/12/1900 which I want to be blank.

Thanks.

7. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

Thanks for replying Belinda, but I still require the formula of S3+365 to be displayed in the Eye Sight Test R3 cell. Everything else did work. So thanks. I just that formula in there somehow.

Kevin.

8. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

=IF(AND(S3="",T3=""),"",IF(T3="",\$S3+365,"Complete"))

9. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

Wow!
Thanks for this it works a treat. I will have to work out how the formula works now! I don't just like to copy.

Much appreciated!!

Kevin.

10. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

I suppose you are adding 365 to add a year. Is it important that leap years be taken into account ? Or should the date be a weekday ? ( I guess not, just to be sure)

11. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

Pepe has a point. This might be more reliable:

=IF(AND(S3="",T3=""),"",IF(T3="",EDATE(\$S3,12),"Complete"))

12. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

Hi,
So I assume the ,12 after EDATE refers to 12 months? I have just looked up the EDATE function and I didn't know about that. Looks good so I will put that into my spreadsheet. Thanks for all your help! I was banging my head against a brick wall before this.

Kevin.

13. ## Re: Populate same Cell with 2 possible out comes with If(isblank)

Yes, that's right.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

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