Number to Words
Closed
syed abdulrahman
TrowaD
- Posts
- 1
- Registration date
- Tuesday June 4, 2013
- Status
- Member
- Last seen
- June 4, 2013
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
2 replies
TrowaD
Jun 4, 2013 at 11:09 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jun 4, 2013 at 11:09 AM
=IF(LEFT(I23,1)="9","NINE",IF(LEFT(I23,1)="8","EIGHT",IF(LEFT(I23,1)="7","SEVEN",IF(LEFT(I23,1)="6","SIX",IF(LEFT(I23,1)="5","FIVE",IF(LEFT(I23,1)="4","FOUR",IF(LEFT(I23,1)="3","THREE")))))))
TrowaD
Jun 6, 2013 at 10:41 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jun 6, 2013 at 10:41 AM
Nice try Mark, but you will need a whole lot more IF functions if you want to solve it that way.
TrowaD
Jun 10, 2013 at 10:22 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jun 10, 2013 at 10:22 AM
Well I have to agree with you too, but I guessed encouragement was all he needed.