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.