Multiple logic formula

Report
-
Posts
1919
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 10, 2021
-
Hello,

I have 2 columns with separate pieces of information:
Column A = Wood or Plastic
Column B = 1 or 2

How do I build a formula which can define 4 different results.

Wood & 1 = 27
Wood & 2 = 38
Plastic & 1 = 48
Plastic & 2 = 57

Thanks
System Configuration: Windows / Chrome 90.0.4430.93

1 reply

Posts
1919
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 10, 2021
143
LTeron, Good evening.

If your possible data are these four values, you can use this formula:

C1 --> =IF(A1="Plastic"; IF(B1=1;48;57); IF(B1=1;27;38))

Please, tell us if it worked as you wanted.

I hope it helps.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!