# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I want to use the IF function to find out the Vintage of an employee from Date of joining
Solved by V. D. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/02/2018 - 02:01
Hello! Welcome to Excel Chat.
Excelchat Expert 05/02/2018 - 02:02
User 05/02/2018 - 02:02
Hi
User 05/02/2018 - 02:02
I want to know if the date of joining of an employee is 12th Jan 2016 then as on date what will be his total vintage in the organisation?
User 05/02/2018 - 02:03
what formula should I type ..
Excelchat Expert 05/02/2018 - 02:03
Vintage is equal to the length of the service till date? Let me know if my understanding is corrrect.
User 05/02/2018 - 02:03
yes
Excelchat Expert 05/02/2018 - 02:04
Ok. Let me work out a formula for you then.
User 05/02/2018 - 02:04
Excelchat Expert 05/02/2018 - 02:05
Sure. In what units, you would like to get the result?
User 05/02/2018 - 02:06
In number of days
Excelchat Expert 05/02/2018 - 02:06
Ok.
User 05/02/2018 - 02:06
I also need to know how do i spolit that in 0-6 months : 6-12 months etc
Excelchat Expert 05/02/2018 - 02:07
Ok. Just give me a moment to work on your problem.
Excelchat Expert 05/02/2018 - 02:08
Excelchat Expert 05/02/2018 - 02:09
In cell A1, there is the first date, i.e. date of joining.
Excelchat Expert 05/02/2018 - 02:09
In cell B2, is today's date.
User 05/02/2018 - 02:09
how do i split it into 0-6 mths, 6-9 months and 9-12 months
User 05/02/2018 - 02:09
need to know the IF and ISERROR functions
Excelchat Expert 05/02/2018 - 02:09
Ok, now you want to categorize in different categories?
User 05/02/2018 - 02:10
yes
Excelchat Expert 05/02/2018 - 02:10
Then let's use the month diff, then
User 05/02/2018 - 02:10
ok
Excelchat Expert 05/02/2018 - 02:10
In cell C2, you can see 24 now.
Excelchat Expert 05/02/2018 - 02:10
This is 24 month that is the difference between two dates.
Excelchat Expert 05/02/2018 - 02:11
Now we will use this further.
Excelchat Expert 05/02/2018 - 02:13
Give me a moment to improve it further.
Excelchat Expert 05/02/2018 - 02:16
Sorry to keep you waiting.
Excelchat Expert 05/02/2018 - 02:16
I have updated the formula in D1.
Excelchat Expert 05/02/2018 - 02:16
User 05/02/2018 - 02:18
Give me few mins to verify ..
Excelchat Expert 05/02/2018 - 02:18
Sure.
Excelchat Expert 05/02/2018 - 02:18
After that, I will explain the solution.
User 05/02/2018 - 02:20
Can you explain me Cl D formula please
Excelchat Expert 05/02/2018 - 02:20
Ok.
Excelchat Expert 05/02/2018 - 02:21
In cell C1, it's a simple Date difference formula, where 3 inputs are required, first date, second date, and the unit in which we want to see the results.
Excelchat Expert 05/02/2018 - 02:21
=DateDif(A1, B1, "M")
User 05/02/2018 - 02:22
ok understood the Cl C
Excelchat Expert 05/02/2018 - 02:22
here M is for month. you can use "Y" for year, "D" for days. You can also use combination of them like "YMD" or "YM" or "MD" etc.
Excelchat Expert 05/02/2018 - 02:22
Great!
Excelchat Expert 05/02/2018 - 02:23
In D1, it's a nested IF formula.
Excelchat Expert 05/02/2018 - 02:24
IF also need 3 inputs, 1 - condition that is to be checked, 2 - Result if given condition is true, 3 - Result if given condition is false (optional).
Excelchat Expert 05/02/2018 - 02:25
So I am checking C1 for a value, and if that condition is true, give me the first message, if that condition is false, check again C1 for a new value. And so on.
Excelchat Expert 05/02/2018 - 02:25
Here I used, IF in another IF 2 times more.
Excelchat Expert 05/02/2018 - 02:26
Excel has a limit that you can put upto 8 IF inside an IF.
Excelchat Expert 05/02/2018 - 02:26
I hope I was able to explain the solution, please let me know if you have any question.
User 05/02/2018 - 02:28
thx
User 05/02/2018 - 02:29
where can i find teh list of formulas if i dont know
User 05/02/2018 - 02:29
which formula to apply
Excelchat Expert 05/02/2018 - 02:29
You can Google for Excel formulas and Excel help.
User 05/02/2018 - 02:30
can u suggest a link .. also do you guys provide class room trainings ?
Excelchat Expert 05/02/2018 - 02:30
Which formula to apply is dependent on question.
Excelchat Expert 05/02/2018 - 02:30
I am sorry, there is no class room training for now.
Excelchat Expert 05/02/2018 - 02:31
User 05/02/2018 - 02:31
so if I enroll with Got IT Pro ..can I get assistance for the formulas I need
Excelchat Expert 05/02/2018 - 02:31
Yes. For each question, you can start a new session and an expert will be there for help.
Excelchat Expert 05/02/2018 - 02:35
Have a nice day ahead. Bye!

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.