Multiple logic formula

Closed
LTeron - May 10, 2021 at 06:05 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 10, 2021 at 07:30 PM
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
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 10, 2021 at 07:30 PM
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.
0