Asking for Formula ~ Thanks!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: raspywench <raspywench.1v0pil_1126145272.206@xxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 7 Sep 2005 20:44:30 -0500

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?action=getinfo&userid=20717
View this thread: http://www.excelforum.com/showthread.php?threadid=465785

.

Follow-Ups:
- Re: Asking for Formula ~ Thanks!
  - From: Biff

Prev by Date: Re: Adding and Naming Multiple Worksheets
Next by Date: RE: Adding and Naming Multiple Worksheets
Previous by thread: Verifying Dates
Next by thread: Re: Asking for Formula ~ Thanks!
Index(es):
- Date
- Thread