R
raspywench
I am trying to write a formula for the following:
If A2=A then use IF statement 1, If A2=B then use IF statement 2, If
A2=C then use IF statement 3.
I have the if statements written and working (like the one below) but
cannot put this all together and nest them properly.
IF(Production!AA4<='Control Page'!$A$4,'Control
Page'!$B$4,IF(Production!AA4<='Control Page'!$A$5,'Control
Page'!$B$5,IF(Production!AA4<='Control Page'!$A$6,'Control
Page'!$B$6,IF(Production!AA4<='Control Page'!$A$7,'Control
Page'!$B$7,IF(Production!AA4<='Control Page'!$A$8,'Control
Page'!$B$8,IF(Production!AA4<='Control Page'!$A$9,'Control
Page'!$B$9,IF(Production!AA4>'Control Page'!$A$9,'Control
Page'!$B$10)))))))*Production!Y4
Any help would be much appreciated.
Thank you!
If A2=A then use IF statement 1, If A2=B then use IF statement 2, If
A2=C then use IF statement 3.
I have the if statements written and working (like the one below) but
cannot put this all together and nest them properly.
IF(Production!AA4<='Control Page'!$A$4,'Control
Page'!$B$4,IF(Production!AA4<='Control Page'!$A$5,'Control
Page'!$B$5,IF(Production!AA4<='Control Page'!$A$6,'Control
Page'!$B$6,IF(Production!AA4<='Control Page'!$A$7,'Control
Page'!$B$7,IF(Production!AA4<='Control Page'!$A$8,'Control
Page'!$B$8,IF(Production!AA4<='Control Page'!$A$9,'Control
Page'!$B$9,IF(Production!AA4>'Control Page'!$A$9,'Control
Page'!$B$10)))))))*Production!Y4
Any help would be much appreciated.
Thank you!