# Nested IF to return text string based on certain conditions

1. ## Nested IF to return text string based on certain conditions

Hi Guys,

I hope you can help, please.

I have attached the excel file, but I will also explain.

> The assess date and the actual date is always the first day in the month.

> In every scenario, where the assess date is prior to the actual date, it needs to return error

> One exception to this, is when the assess date is exactly one month prior to the actual date, it needs to return "staging"

> Where the assess date and the actual date are equal, or the assess date always exceeds the actual date, it needs to return "subsequent"

I have kindly received help on here previously, but I could not get the formula to work based on the fact that both assess and actual are now the first day in the month.

Any help greatly appreciated.

Thanks!

2. ## Re: Nested IF to return text string based on certain conditions

You may try this nested IF formula (see attachment)

=IF(SUM(D4-C4)>30,"Error",IF(OR(SUM(D4-C4)=31,SUM(D4-C4)=30,SUM(D4-C4)=28,SUM(D4-C4)=29),"Staging",IF(SUM(D4-C4)<1,"Subsequent")))

Remember to drag down to last entry

3. ## Re: Nested IF to return text string based on certain conditions

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

4. ## Re: Nested IF to return text string based on certain conditions

Guys! thanks so much. Much appreciated.

5. ## Re: Nested IF to return text string based on certain conditions

You're welcome. Thanks for the feedback and rep.

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