**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I would like to insert a formula to add something (Maybe a 'Y') if a cell contains 14 days or less. Is this possible?

Solved by F. H. in 6 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

User
07/09/2017 - 09:56

Hi

User
07/09/2017 - 09:56

This is basically what I have

Excelchat Expert
07/09/2017 - 09:56

Welcome, Thanks for choosing Got It Pro-Excel.

Excelchat Expert
07/09/2017 - 09:56

I understand that you need help with IF formula.

User
07/09/2017 - 09:56

And want to add and indicator where the X's her

User
07/09/2017 - 09:56

thanks

Excelchat Expert
07/09/2017 - 09:57

If below 14 days is 'Y'?

Excelchat Expert
07/09/2017 - 09:57

Otherwise, XX?

User
07/09/2017 - 09:57

Dont really need an XX for otherwise

User
07/09/2017 - 09:58

just an indicator for under 14 days really

Excelchat Expert
07/09/2017 - 09:59

Entering Explanation Phase

Excelchat Expert
07/09/2017 - 09:59

Is that the formula you are looking for?

User
07/09/2017 - 10:00

Looks great!

Excelchat Expert
07/09/2017 - 10:00

Wait let me revise that

Excelchat Expert
07/09/2017 - 10:00

Oh ok, you'll have no problem with 1 digit.

Excelchat Expert
07/09/2017 - 10:00

Entering Discussion Phase

Excelchat Expert
07/09/2017 - 10:00

Would there be anything else that I can help you with regards to the original question?

User
07/09/2017 - 10:01

What does LEFT indicate in the formula?

Excelchat Expert
07/09/2017 - 10:01

LEFT(text, number of characters to return starting from the left of text)

Excelchat Expert
07/09/2017 - 10:01

Example

User
07/09/2017 - 10:02

righht

Excelchat Expert
07/09/2017 - 10:02

=LEFT("ABCDEF",4) should return ABCD

User
07/09/2017 - 10:02

and the 2 indicates the amount of characters to recognise

User
07/09/2017 - 10:02

excellent

User
07/09/2017 - 10:02

thank you for you help

Excelchat Expert
07/09/2017 - 10:02

No worries. :)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*