Using Find or Search to extract data starting point from a formula

Morning all,

Thought this would be relatively straight-forward, but cannot crack it?!

I have the following formula all the way down a column:

=(F9*0.7)-H9

And the only thing that changes is the 0.7 to 0.55 or another such percentage, and this is what I want to pull out of the formula and show in another column.

This seems like a simple MID/FIND/LEN moment, but I've tried using FIND and SEARCH to get a starting point but not getting any luck.

I've looked online and there doesn't seem to be a way of extracting data from a formula without either VB or copying and pasting as text, does anyone have a quick and simple formula driven answer please??

Many thanks in advance,
Mike

Hi Xor,
This will be a monthly task, performed by an external shared services function, so I'm trying to give them a dynamic formula that they can just drop into the spreadsheet without having to copy&paste special values or insert a ' before the formula.

For illustration, if I just had text of
'=(F9*0.7)-H9

this is the formula I would use
=MID(I9,FIND("*",I9)+1,FIND(")",I9)-1-FIND("*",I9))

and the result would be 0.7 which is exactly what I want to extract

Is there any way I can change to first formula to text or something that would allow this to work???

Thanks,
Mike

Thanks Dileep. Should have mentioned it but I've already cleared up the reverse calculation side of this.

It's basically a two-part check; first is the reverse calculation to find out the percentage rate applied by the customer, second is to see what it should have been as on occasion they submit incorrect calculations and I'm trying to find a quick way to highlight these.

It's a weird one but all I need is a way to extract the starting point and I'll be set, but beginning to think I may be out of luck here...

Thanks,
Mike

I'd be happy with VB, but unfortunately the shared service function not

Thanks XOR LX & dileepc, appreciate your input but was really just looking for a function or formula to drop into the spreadsheet requiring minimal fuss, but think our discussions have confirmed that there's no function that can search within a formula to bring back the formula text rather than the result.

Thanks again,
Mike