Multiple logic formula

Report
-
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
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
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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.