shanenicholson88
New Member
- Joined
- Oct 6, 2020
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Good morning all,
I have the following formula on one of my spreadsheets, written by an excel wizard. I am trying to figure out what exactly this is doing. I know what the functions do individually, but not like thiis.
Any help will be much appreciated, and thank you in advance to taking the time to read it.
I have the following formula on one of my spreadsheets, written by an excel wizard. I am trying to figure out what exactly this is doing. I know what the functions do individually, but not like thiis.
Any help will be much appreciated, and thank you in advance to taking the time to read it.
Excel Formula:
=IF(LEN(M6)=3,LEFT(M6,1),LEFT(M6,2))*100