LEFT(F17, 5), "Part A - No Match", IF(LEFT(F17, 5)=LEFT(L16, 5) & MID(F17, 6, 6)= MID(F17, 18, 1) ), "PART C HIGH MATCH", "LOW MATCH" ) )" /> LEFT(F17, 5), "Part A - No Match", IF(LEFT(F17, 5)=LEFT(L16, 5) & MID(F17, 6, 6)= MID(F17, 18, 1) ), "PART C HIGH MATCH", "LOW MATCH" ) )"> LEFT(F17, 5), "Part A - No Match", IF(LEFT(F17, 5)=LEFT(L16, 5) & MID(F17, 6, 6)= MID(F17, 18, 1) ), "PART C HIGH MATCH", "LOW MATCH" ) )" />

Excel logic!

30.0 GBP

30.0 GBP peopleperhour Technology & Programming Overseas
4 hour ago

Description

I have the 3 parts that work indpendendtly.
But am trying to combine but does not work. Tried chat ChatGOT.
Ideally what i want is something like "Part A - Exact Matc_Part B- Exact Match_Part C - LOW MATCH" etc
PART A

=IF(LEFT(F17, 11)=LEFT(L16, 11), "Part A - Exact Match", IF(LEFT(L16, 5)<>LEFT(F17, 5), "Part A - No Match", IF(LEFT(F17, 5)=LEFT(L16, 5) & MID(F17, 6, 6)= MID(F17, 18, 1) ), "PART C HIGH MATCH", "LOW MATCH" ))

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

We are seeking an experienced Learning Management System (LMS) Developer to create a custom LMS platform tailored for online PDF and video-based learning. The platform must support SCORM files, interactive quizzes, and automated certificates. Project Requirements: Content Delivery: Seamless integration for PDF, video-based modules, and SCORM-compliant courses (SCORM files will be provided). User-Friendly Interface: Easy navigation for both learners and administrators. Quizzes & Assessments: Customizable quizzes at the end of each module. Certificates: Automated certificate generation upon course completion. Progress Tracking: Track learners' progress and generate reports. Mobile Responsiveness: Ensure a smooth experience across all devices. Admin Dashboard: Easy-to-use dashboard for managing content, users, and reports. Reseller Functionality: Ability for resellers to sell courses through their own accounts. Corporate Access: Companies should have their own admin access to set up users, manage employee enrollments, and monitor progress reports. Preferred Skills: Proven experience in LMS development Familiarity with popular LMS frameworks and SCORM-compliant systems Knowledge of integrations (e.g., video hosting, PDF readers, etc.) Strong backend and frontend development skills Experience with multi-tenant systems for resellers and corporate clients To Apply: Please submit your portfolio, a brief proposal outlining your approach, and a timeline for the project. Let us know how you will ensure scalability, security, and efficiency. We look forward to collaborating with you!
363.0 GBP Technology & Programming peopleperhour Overseas
2 days ago
Please read carefully and NO COPY & PASTE OR BOT RESPONSES PLEASE - INSTANT DELETE! We are seeking a talented and experienced web developer to undertake the completion of our website www.emdeeglobal.com. Our firm specializes in management consulting, offering a suite of services to help businesses achieve strategic objectives. The website should be a one-stop shop, fully responsive, fast, secure, We aim to repackage our services for better client engagement. Objectives: Fully Responsive Design: Ensure the website is mobile-friendly and adapts seamlessly to all devices. Speed and Security Enhancements: Implement optimizations for faster loading times and strengthen security measures. Content Revamp: Utilize provided content to highlight our consulting services and solutions, making them accessible and comprehensible to visitors. SEO and Social Media Integration: Optimize the site for search engines Visual and Layout Improvements: Refresh current images and layouts with a modern touch, open to suggestions for enhancements. Packaging Services: Creatively bundle our offerings to showcase our comprehensive solutions in business and management consulting. Requirements: Proven experience in web design and development, especially with responsive and secure websites. Expertise in SEO, social media integration. Ability to work with existing content and visuals while proposing innovative improvements. Excellent communication skills and a collaborative approach to incorporate feedback and suggestions. Please provide your portfolio showcasing similar projects, a detailed quote, and your approach to fulfilling the project objectives. Attached are the relevant page content and general instructions. Please ask any questions BEFORE bidding!
120.0 GBP Technology & Programming peopleperhour Overseas
3 hour ago