discount formula

[makinmomb]

I have these starting a1 downwards

!!! ON SALE !!!
KOTEX LONGER 8 3 IN 1
WAS : 3000
THEN : 2200
NOW : 1500
SAVE 50%
EXPIRE 23-12-2020

I want formula on A6 , to compute the 50% automatically , since it is mixed with text i am
not able to handle that

File attached too

[etaf]

try
="SAVE : "&TEXT((RIGHT(A5,LEN(A5)-FIND(":",A5,1))*1/RIGHT(A3,LEN(A3)-FIND(":",A3,1))*1)*1,"0.0%")

[Glenn Kennedy]

How can the formula be in A6, when the string, from which you wish to extract the percentage, is located in A6??!

So... in any OTHER cell:

=-LOOKUP(1,-RIGHT(TRIM(LEFT(A6,FIND("%",A6)-1)),{1,2,3,4,5,6,7,8,9}))/100

format as %

[Bo_Ry]

Please try

="SAVE "&TEXT(PRODUCT(INDEX(MID(A3:A5,FIND(":",A3:A5)+1,9)^{-1;0;1},)),"0%")

or

=PRODUCT(INDEX(MID(A3:A5,FIND(":",A3:A5)+1,9)^{-1;0;1},))

and custom format "SAVE" 0%

[bebo021999]

Assuming it always be "WAS divided by (/) NOW":

Please Login or Register  to view this content.

Enter only.

[makinmomb]

bebo formula will work if teh compute is as follows ,

7500 WAS
4350 NOW
3150 DISCOUNT
42%

I am doing each label manually by dividing through calculator 3150 divide by 7500

when i change the 1500 to 1000 on bebo formula it reads me 33% instead of 67%
2000 divide 3000

[makinmomb]

Here is what i do at each label look at sheet2 , complete manual process

8 labels 8 times compute

[Bo_Ry]

Try this and
=1-PRODUCT(INDEX(MID(A3:A5,FIND(":",A3:A5)+1,9)^{-1;0;1},))

and custom format "SAVE" 0%

copy to other cells