LinkBack URL
About LinkBacks
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!!
With A1 containing some text...326KA80000
This formula assigns a percent to the 5th character
EDITED TO INCLUDE THIS ALTERNATIVE THAT ALLOWS FOR SHORT TEXT
Please Login or Register to view this content.
Format B1 as percent.Please Login or Register to view this content.
In that example, the formula returns: 10%
Is that something you can work with?
Last edited by Ron Coderre; 02-10-2016 at 10:11 AM.
Thanks Ron!
That almost works but the outcome can change and not always in multiples, my actual current requirements are below if you can help me further!
A= -50%
B= -30%
C= -15%
D= 5%
E= 15%
F= 35%
Thanks again!
Create the 2 column table in A1:B6...
Data Range
Then, this formula entered in E1:
=VLOOKUP(MID(D1,5,1),A1:B6,2,0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try with LOOKUP:
=LOOKUP(MID(A1,5,1),{"A","B","C","D","E","F"},{-50,-30,-15,5,15,35}/100)
Quang PT
Thank you this works perfectly!!
Is there any way I can now increase cost price in cell "B1" by the outcome percentage below using just one formula??
Originally Posted by bebo021999
Re: Turning the 5th digit of a cell to output different number?
Duplicate Duplicate
Last edited by richyrich92; 02-10-2016 at 12:11 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks