Add & Remove Rounding Formula

[SUMIF]

Hello

I'm using the following code (borrowed from another forum) to add the rounding formula to selected cells:

Please Login or Register  to view this content.

Whilst the above formula works quite well, i'd like to have the option of removing the Rounding formula. I've therefore amended the code above into the following code:

Please Login or Register  to view this content.

This RemoveRounding code does not seem to work because of this line

Please Login or Register  to view this content.

. I think the problem is that whilst i'm able to strip out "=Rounding(" i am not able to remove the end part of the rounding formula ",2)".

Any suggestions on how i can extract x from the rounding formula e.g. x from "=Rounding(x,2)"

Ideally i'd be able to toggle between adding the rounding formula and removing the rounding formula.

Thanks in advance

[JBeaucaire]

Maybe something like this;

Please Login or Register  to view this content.

[SUMIF]

Maybe something like this;

Please Login or Register  to view this content.

That's perfect! Many thanks for showing me the way

Have a good weekend!