|
Asking for Formula ~ Thanks!
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! -- raspywench ------------------------------------------------------------------------ raspywench's Profile: http://www.excelforum.com/member.php...o&userid=20717 View this thread: http://www.excelforum.com/showthread...hreadid=465785 |
Hi!
Here's an idea..... As I understand your post you have 3 IF formulas like: 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 Give each of these formulas a defined name, something like IF1, IF2, IF3. Then: =CHOOSE(MATCH(A2,{"A","B","C"},0),IF1,IF2,IF3) Biff "raspywench" wrote in message ... 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! -- raspywench ------------------------------------------------------------------------ raspywench's Profile: http://www.excelforum.com/member.php...o&userid=20717 View this thread: http://www.excelforum.com/showthread...hreadid=465785 |
OR, more simply......
Just put each of those IF formulas in a cell, say: The result of IF 1 is in cell C1 The result of IF 2 is in cell D1 The result of IF 3 is in cell E1 Then: =CHOOSE(MATCH(A2,{"A","B","C"},0),C1,D1,E1) Biff "Biff" wrote in message ... Hi! Here's an idea..... As I understand your post you have 3 IF formulas like: 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 Give each of these formulas a defined name, something like IF1, IF2, IF3. Then: =CHOOSE(MATCH(A2,{"A","B","C"},0),IF1,IF2,IF3) Biff "raspywench" wrote in message ... 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! -- raspywench ------------------------------------------------------------------------ raspywench's Profile: http://www.excelforum.com/member.php...o&userid=20717 View this thread: http://www.excelforum.com/showthread...hreadid=465785 |
| All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com