Multiple logic formula

Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 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
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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.