Need Help With This Excel Function!!! - Education - Nairaland
Nairaland Forum › Nairaland General › Education › Need Help With This Excel Function!!! (271 Views)
| Need Help With This Excel Function!!! by eniola1010(op): 4:39pm On Jan 08, 2025 |
Assuming we’re in the year 2014. How can i get the full year of column A and put in column B. For example B2 will be 2006 and B5 will be 1998, etc. i have tried =IF(A2=<14,A2+2000,A2+1900) its not working.
|
| Re: Need Help With This Excel Function!!! by Stephen0mozzy: 5:02pm On Jan 08, 2025 |
I think the issue is that your data in column A is not a number, but formatted as a text. Use this formula =IF(A1*1>14,1900+A1*1,2000+A1*1) Multiplying the text in each by 1 will convert it to a number which you can then use for conparison with greater than, less than et al You may want to wrap the function inside an IFERROR incase you meet a cell that can't be parsed to a number e.g O instead of zero Or.... Just change the formatting in column A to numbers, and your former function will work |
| Re: Need Help With This Excel Function!!! by AndroBlaze: 8:49pm On Jan 08, 2025 |
eniola1010: Hmmm....is 14 (2014) the highest year available in your sample? If so the logic for your formula should work for now, unless those numbers in column A are not recognised as numbers and Excel is reading them as text. It would also help to show us the error you are getting. EDIT: Just thought about it, "06" as depicted in your image cannot be recognised as a number by Excel. You need to change the format or concaat the year itself as text. |
| Re: Need Help With This Excel Function!!! by dammybrite: 10:40pm On Jan 08, 2025 |
Copy and paste as values first, so that it'll be recognised as a number before applying your formula |
| Re: Need Help With This Excel Function!!! by eniola1010(op): 11:07pm On Jan 08, 2025 |
AndroBlaze:Ur solution worked Excel was reading it as a text So i had to add VALUE to the function As for the 2014, its assumed that the year is 2014 and we are trying to see how old the cars are, 06 asin 2006, so 2014-2006 meaning the car is 8 years old 1 Like |
What's The Function Of This Structure Please? • Prison Inmates Excel In WAEC Exams- NPS • Automated Excel Based Broadsheets created For Teachers by a Teacher • 2 • 3 • 4
Best Devops Engineer Course Certification In 2025 • 5 Fully Funded Scholarships 2025 (for International Students) • UNIZIK Expels Student Involved In Assault Of Lecturer