Forum Discussion
abanerjee
Feb 14, 2019Copper Contributor
Excel formula help for auto populate
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 col...
Rich99
Feb 14, 2019Iron Contributor
Hi,
This should work,=IF(A1="P","x+y",IF(A1="Q","x-y",IF(A1="R","x*y", IF(A1="S","x/y"))))
This should work,=IF(A1="P","x+y",IF(A1="Q","x-y",IF(A1="R","x*y", IF(A1="S","x/y"))))