Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lydia Hughes   on Oct 10 In MS Office Category.

Len function help


  
Question Answered By: Allan Bailey   on Oct 10

Try simplifying your IF statement:

If Right(sHold, 2) = "01" Then
sHold = Left(sHold, Len(sHold) - 2) * 2
ElseIf Right(sHold, 2) = "02" Then
sHold = sHold * 2 + 1
Else
sHold = sHold
End If

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Len function help Or get search suggestion and latest updates.


Tagged: