If then, adding more choices
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! |
If then, adding more choices
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)))) sandygiz wrote: 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! |
If then, adding more choices
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 "sandygiz" wrote in message ... 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! |
If then, adding more choices
maybe like this:
=IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3)))) -- Hope that helps. Vergel Adriano "sandygiz" wrote: 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! |
If then, adding more choices
Thank you so much!!
"Philip Reece-Heal" wrote: 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 "sandygiz" wrote in message ... 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! |
If then, adding more choices
=E6*CHOOSE(A6,D3,E3,F3,G3)
Tim "Vergel Adriano" wrote in message ... maybe like this: =IF(A6=1, E6*D3, IF(A6=2, E6*E3, IF(A6=3, E6*F3, IF(A6=4, E6*G3)))) -- Hope that helps. Vergel Adriano "sandygiz" wrote: 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! |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com