I have many rows of a formula in several hundred worksheets similar to:
=If(q5="I",a1*b1,if(MED="P",a1*b2,a1*b3))
where MED is a named range for column Q.
The formula uses both a relative reference, i.e., Q5 and a named reference, i.e., MED to signify the same cell (don't ask me why
I would like to remove the named range reference from the formula, and replace it with Q5 etc...
Thank you!
=If(q5="I",a1*b1,if(MED="P",a1*b2,a1*b3))
where MED is a named range for column Q.
The formula uses both a relative reference, i.e., Q5 and a named reference, i.e., MED to signify the same cell (don't ask me why
I would like to remove the named range reference from the formula, and replace it with Q5 etc...
Thank you!