A.I.M. Users Bulletin Board

[Conrad]

That’s a good lead, Grabber!
I will look at it.

I have agreed with everybody that conditional functions will work!
I once made this one

=IF(AND(ABS(G16)>=F15*$H$4;G16>0);G16*$O$5;IF(AND(ABS(G16)>=F15*$H$7;G16<0);G16*$O$7;0))

and it works fine. I am still amazed that I could do that. I have trouble fathoming the wisdom I had back then!

So, after I got the hint from Clive to use conditionals the problem was essentially solved, but I would have to rewrite all the statements in the spread that I need to freeze.

Thanks for the link!