Hi,

does anyone know what is wrong with the following if statement?

=IF(C2BL2;(C2-BL2)*BX2+BR2*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,I F(C2BK2;(C2-BR2)*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BJ2 ;(C2-BQ2)*BV2+BP2*BU2+BO2*BT2+BN2*BS2,
IF(C2BI2;(C2-BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BH2;(C2-BO2)*BT2+BN2*BS2;C2*BN2)

What I'm trying to do is make Excel do calculations based on depending on
the value in cell C2 in this case. As far as I know it should be possible to
use several IFs like =IF(A=1;Green, IF(A=2,Red, IF(A=3, Blue))) or is there
another function that is more suitable for these calculations?

Best regards Bell

Well to start you are using both , and ; as delimiters. It should be one or
the other.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bell" wrote in message
...
Hi,

does anyone know what is wrong with the following if statement?


=IF(C2BL2;(C2-BL2)*BX2+BR2*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,I F(C2BK2;(C
2-BR2)*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BJ2 ;(C2-BQ2)*BV2+BP2*BU2+BO
2*BT2+BN2*BS2,

IF(C2BI2;(C2-BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BH2;(C2-BO2)*BT2+BN2*BS2;C2*BN2)

What I'm trying to do is make Excel do calculations based on depending on
the value in cell C2 in this case. As far as I know it should be possible
to
use several IFs like =IF(A=1;Green, IF(A=2,Red, IF(A=3, Blue))) or is
there
another function that is more suitable for these calculations?

Best regards Bell

On Fri, 14 Oct 2005 06:19:03 -0700, "Bell"
wrote:

Hi,

does anyone know what is wrong with the following if statement?

=IF(C2BL2;(C2-BL2)*BX2+BR2*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,I F(C2BK2;(C2-BR2)*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BJ2 ;(C2-BQ2)*BV2+BP2*BU2+BO2*BT2+BN2*BS2,
IF(C2BI2;(C2-BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BH2;(C2-BO2)*BT2+BN2*BS2;C2*BN2)

What I'm trying to do is make Excel do calculations based on depending on
the value in cell C2 in this case. As far as I know it should be possible to
use several IFs like =IF(A=1;Green, IF(A=2,Red, IF(A=3, Blue))) or is there
another function that is more suitable for these calculations?

Best regards Bell

You can nest up to 7 IF statements. It appears you've got 4 which is
OK, but I'd expect there to be four ")" at the end rather than just
one.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

For what I know ; are used as delimiters between criteria, truepart and
falsepart whereas , are used for "starting" an additional if statement.

Am I wrong?

"Bob Phillips" skrev:

Well to start you are using both , and ; as delimiters. It should be one or
the other.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bell" wrote in message
...
Hi,

does anyone know what is wrong with the following if statement?


=IF(C2BL2;(C2-BL2)*BX2+BR2*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,I F(C2BK2;(C
2-BR2)*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BJ2 ;(C2-BQ2)*BV2+BP2*BU2+BO
2*BT2+BN2*BS2,

IF(C2BI2;(C2-BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BH2;(C2-BO2)*BT2+BN2*BS2;C2*BN2)

What I'm trying to do is make Excel do calculations based on depending on
the value in cell C2 in this case. As far as I know it should be possible
to
use several IFs like =IF(A=1;Green, IF(A=2,Red, IF(A=3, Blue))) or is
there
another function that is more suitable for these calculations?

Best regards Bell

I think so. AFAIK, they are the same. The difference comes between
continental versions of Excel and the rest.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bell" wrote in message
...
For what I know ; are used as delimiters between criteria, truepart and
falsepart whereas , are used for "starting" an additional if statement.

Am I wrong?

"Bob Phillips" skrev:

Well to start you are using both , and ; as delimiters. It should be one
or
the other.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bell" wrote in message
...
Hi,

does anyone know what is wrong with the following if statement?



=IF(C2BL2;(C2-BL2)*BX2+BR2*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,I F(C2BK2;(C

2-BR2)*BW2+BQ2*BV2+BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BJ2 ;(C2-BQ2)*BV2+BP2*BU2+BO
2*BT2+BN2*BS2,


IF(C2BI2;(C2-BP2*BU2+BO2*BT2+BN2*BS2,IF(C2BH2;(C2-BO2)*BT2+BN2*BS2;C2*BN2)

What I'm trying to do is make Excel do calculations based on depending
on
the value in cell C2 in this case. As far as I know it should be
possible
to
use several IFs like =IF(A=1;Green, IF(A=2,Red, IF(A=3, Blue))) or is
there
another function that is more suitable for these calculations?

Best regards Bell