Puzzled with this one if you anyone could help me out!!
If the 5th letter of a cell is either of the below I need to output a different percentage..
A=10%
B=20%
C=30%
D=40%
E=50%
So "326KA80000" would equal "10%"
Cheers!!![]()
Puzzled with this one if you anyone could help me out!!
If the 5th letter of a cell is either of the below I need to output a different percentage..
A=10%
B=20%
C=30%
D=40%
E=50%
So "326KA80000" would equal "10%"
Cheers!!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks