If, then, else statement
 

Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

If, then, else statement
 

Look in the help index for AND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ACarella" wrote in message
...
Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

If, then, else statement
 

M10: =IF(AND(D10<K10,D10<0),L10,"")

and use that same formula in conditional formatting for L10

--
__________________________________
HTH

Bob

"ACarella" wrote in message
...
Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

If, then, else statement
 

Thank you both for your help.
However, one of my If statements was incorrect.
This is what it should be and I cannot get the third IF statement to
function properly
=IF(D10<K10,L10,IF(D10=K10,F10,IF(B10<C10,D10)))

The 3rd If Statement is the issue. No matter what I do, it doesn't work.
B10 can be blank, so I tried IF B10=' ', D10 or IF B10=0, D10, or IF B10 is
blank, 0
I just can't get it to work. Then it would be the same if this condition
was true then highlight and bold L10
Please help, thank you.

"Don Guillett" wrote:


Look in the help index for AND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ACarella" wrote in message
...
Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

If, then, else statement
 

No you don't seem to understand, ONE OF THE FIRST TWO IF's ARE ALWAYS
TRUE! The third IF will NEVER be reached to be acted upon.

ACarella wrote:

Thank you both for your help.
However, one of my If statements was incorrect.
This is what it should be and I cannot get the third IF statement to
function properly
=IF(D10<K10,L10,IF(D10=K10,F10,IF(B10<C10,D10)))

The 3rd If Statement is the issue. No matter what I do, it doesn't work.
B10 can be blank, so I tried IF B10=' ', D10 or IF B10=0, D10, or IF B10 is
blank, 0
I just can't get it to work. Then it would be the same if this condition
was true then highlight and bold L10
Please help, thank you.

"Don Guillett" wrote:


Look in the help index for AND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ACarella" wrote in message
...

Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

If, then, else statement
 

oh, is there a way to rewrite the formula to return the value if any of the
three IF statements are reached?

"Bob I" wrote:

No you don't seem to understand, ONE OF THE FIRST TWO IF's ARE ALWAYS
TRUE! The third IF will NEVER be reached to be acted upon.

ACarella wrote:

Thank you both for your help.
However, one of my If statements was incorrect.
This is what it should be and I cannot get the third IF statement to
function properly
=IF(D10<K10,L10,IF(D10=K10,F10,IF(B10<C10,D10)))

The 3rd If Statement is the issue. No matter what I do, it doesn't work.
B10 can be blank, so I tried IF B10=' ', D10 or IF B10=0, D10, or IF B10 is
blank, 0
I just can't get it to work. Then it would be the same if this condition
was true then highlight and bold L10
Please help, thank you.

"Don Guillett" wrote:


Look in the help index for AND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ACarella" wrote in message
...

Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

If, then, else statement
 

No, it a progression, IF, THEN, ELSE. You will need to place them in
ORDER of the desired outcome. Place the B10 one first. Once you evaluate
to TRUE then that is the last evaluation that is done, game over.

ACarella wrote:

oh, is there a way to rewrite the formula to return the value if any of the
three IF statements are reached?

"Bob I" wrote:


No you don't seem to understand, ONE OF THE FIRST TWO IF's ARE ALWAYS
TRUE! The third IF will NEVER be reached to be acted upon.

ACarella wrote:


Thank you both for your help.
However, one of my If statements was incorrect.
This is what it should be and I cannot get the third IF statement to
function properly
=IF(D10<K10,L10,IF(D10=K10,F10,IF(B10<C10,D10) ))

The 3rd If Statement is the issue. No matter what I do, it doesn't work.
B10 can be blank, so I tried IF B10=' ', D10 or IF B10=0, D10, or IF B10 is
blank, 0
I just can't get it to work. Then it would be the same if this condition
was true then highlight and bold L10
Please help, thank you.

"Don Guillett" wrote:



Look in the help index for AND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ACarella" wrote in message
...


Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

If, then, else statement
 

Hi Bob:
This works and enters the value into M10.
IF(AND(D10<K10,D10<0),L10)
However, if the statement is false it returns
#VALUE!
is there a way to make the statment return 0 if false so that the I can
subtotal on the column?
Thank you.

"Bob Phillips" wrote:

M10: =IF(AND(D10<K10,D10<0),L10,"")

and use that same formula in conditional formatting for L10

--
__________________________________
HTH

Bob

"ACarella" wrote in message
...
Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

If, then, else statement
 

=IF(AND(D10<K10,D10<0),L10,0)

ACarella wrote:
Hi Bob:
This works and enters the value into M10.
IF(AND(D10<K10,D10<0),L10)
However, if the statement is false it returns
#VALUE!
is there a way to make the statment return 0 if false so that the I can
subtotal on the column?
Thank you.

"Bob Phillips" wrote:


M10: =IF(AND(D10<K10,D10<0),L10,"")

and use that same formula in conditional formatting for L10

--
__________________________________
HTH

Bob

"ACarella" wrote in message
...

Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

If, then, else statement
 

You should have used the formula as I gave it to you

--
__________________________________
HTH

Bob

"ACarella" wrote in message
...
Hi Bob:
This works and enters the value into M10.
IF(AND(D10<K10,D10<0),L10)
However, if the statement is false it returns
#VALUE!
is there a way to make the statment return 0 if false so that the I can
subtotal on the column?
Thank you.

"Bob Phillips" wrote:

M10: =IF(AND(D10<K10,D10<0),L10,"")

and use that same formula in conditional formatting for L10

--
__________________________________
HTH

Bob

"ACarella" wrote in message
...
Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene