Nested IF Statment?

[christrz]

Hi all - I'm trying return a calculation based on 3 possible conditions but can't seem to find my way.

What I am trying to do is:

If AA7 = "Tab" then Y7 x AN7
If AA7 = "Broad" then Y7 x AN8
If AA7 = "Q-fold" then Y7 x AN9

Any help is appreciated

C

 

[pagrender]

How about this?

=IF(AA7="Tab",Y7*AN7,IF(AA7="Broad",Y7*AN8,IF(AA7="Q-fold",Y7*AN9,"error")))

You can replace the "error" with whatever you want the value to be if A7 does not equal Tab, Broad, or Q-fold.

Pete

 

[christrz]

That did the trick

Thanks very much

 

[pagrender]

You're welcome. Thanks for the feedback!

 

[Scott Huish]

Also:

=Y7*INDEX(AN7:AN9,MATCH(AA7,{"Tab","Broad","Q-Fold"},0))

 

[christrz]

Thanks again all for the help - I now have sort of a follow up

The nested IF works well and now has 3 iterations which gibe me the KG per copy based on page width.

I now need to display the correct answer based on which one of the 3 iterations is in effect...something like this..

IF U7 = "12" Then cell Z29 displays the answer in cell AN11
IF U7 = "12.5" Then cell Z29 displays the answer in cell AV11
IF U7 = "14" Then cell Z29 displays the answer in cell AR11

I tried using the same syntax as above - but I can't seem to get it to do anything but display the error

Thanks again

 

[T. Valko]

Thanks again all for the help - I now have sort of a follow up

The nested IF works well and now has 3 iterations which gibe me the KG per copy based on page width.

I now need to display the correct answer based on which one of the 3 iterations is in effect...something like this..

IF U7 = "12" Then cell Z29 displays the answer in cell AN11
IF U7 = "12.5" Then cell Z29 displays the answer in cell AV11
IF U7 = "14" Then cell Z29 displays the answer in cell AR11

I tried using the same syntax as above - but I can't seem to get it to do anything but display the error

Thanks again

Entered in Z29:

=IF(U7=12,AN11,IF(U7=12.5,AV11,IF(U7=14,AR11,"")))

 

[christrz]

That did the trick

Thank you very much!

C

 

[T. Valko]

That did the trick

Thank you very much!

C

You're welcome. Thanks for the feedback!