| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
