Category Discount
N15 15%
N10 10%
T5 5%
P10 10%
P5 5%
P2 2%
if i type N15 the outcome will give 15% discount. any idea how to do it?
Here, try this:
=TEXT(LOOKUP(99^99, RIGHT(C3, ROW($A$1:$A$5))/100), "00%")
Where C3 is your cell with data N15, T5 etc.
"Relax. What is mind? No matter. What is matter? Never mind!"
MOTD: Until I taste a lion pig is a King of animals to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks