This is what I am trying to so we have 4 predfined values for column 'A'
For example (P,Q,R,S)
and I want a formula to be automatically inserted in the Column 'B' as per the option I choose in column 'A'
P = x+y
Q = x-y
R = x*y
S = x/y
so if i choose 'P' in a cell in column 'A'
in column 'B' in adjacent cell the formula 'x+y' should be auto populated.
Any help would be highly appreciated.
Note: New in excel and using Microsoft Excel for MAC version 16.21.1