Hi,
I need formula for the below condition.
If cells last two numbers are (from right side) 01 or 02 or 03 then result should be =mid A1,2,2) subtract by 1. if not result should be = mid(A1,2,2)
Row A B
1 19201 91
2 12103 20
3 14502 44
4 12118 21
Kindly help
Regards
Prabhu
Formula:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Formula:Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank You TMS & mehmetcik !!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks