If then, adding more choices

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sandygiz - 18 Sep 2007 17:34 GMT

I am using the following command to direct what happens in column of cells:
=IF(A6=1, E6*D3, IF(A6=2, E6*E3))

This works fine for 2 options, but when I try to add a 3rd & 4th, I get an
error.
=IF(A6=1, E6*D3, IF(A6=2, E6*E3), IF(A6=3, E6*F3), IF(A6=4, E6*G3))))
How do I add more options? I know my parenthesis and probably more are off.

Thanks!

Reply to this Message

JW - 18 Sep 2007 17:37 GMT

You have too many parenthesis.
=IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3))))

> I am using the following command to direct what happens in column of cells:
> =IF(A6=1, E6*D3, IF(A6=2, E6*E3))
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message

Philip Reece-Heal - 18 Sep 2007 17:39 GMT

This seems to work:
=IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3))))

Ie, you dont use a closing bracket after each if argument, you just put a
closing bracket for each if argument at the end of the formula

Philip

>I am using the following command to direct what happens in column of cells:
> =IF(A6=1, E6*D3, IF(A6=2, E6*E3))
[quoted text clipped - 6 lines]
>
> Thanks!

Reply to this Message

sandygiz - 18 Sep 2007 18:04 GMT

Thank you so much!!

> This seems to work:
> =IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3))))
[quoted text clipped - 14 lines]
> >
> > Thanks!

Reply to this Message

Vergel Adriano - 18 Sep 2007 17:40 GMT

maybe like this:

=IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3))))

Signature

Hope that helps.

Vergel Adriano

> I am using the following command to direct what happens in column of cells:
> =IF(A6=1, E6*D3, IF(A6=2, E6*E3))
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message

Tim Williams - 20 Sep 2007 06:44 GMT

=E6*CHOOSE(A6,D3,E3,F3,G3)

Tim

> maybe like this:
>
[quoted text clipped - 12 lines]
>>
>> Thanks!

Reply to this Message