Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to use the conditions? - Liz
I need help with this if anyone can help me with this:
A1=$1500 B1=$1500 I want to create a logic that if B1 is greater or equal to A1 then YES and if B1 is less than A1 then NO. And if the cells A1 or B1 is blank then the result cell should also appear blank and should not show #Value? or other values in the conditioned cell. What should I should to get this conditioned in one cell? Thanks Liz |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to use the conditions? - Liz
This formula should work:
=IF(OR(A1="",B1=""), "", IF(B1 = A1, "YES", "NO")) If A1 or B1 is blank, return a blank, otherwise if B1 is greater or equal than A1 return Yes, otherwise return No. -- Philip Trick Actuarial Consultant "Liz" wrote: I need help with this if anyone can help me with this: A1=$1500 B1=$1500 I want to create a logic that if B1 is greater or equal to A1 then YES and if B1 is less than A1 then NO. And if the cells A1 or B1 is blank then the result cell should also appear blank and should not show #Value? or other values in the conditioned cell. What should I should to get this conditioned in one cell? Thanks Liz |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to use the conditions? - Liz
Hi Liz
Try =IF(A1=B1,"",IF(B1A1,"Yes","No")) -- Regards Roger Govier "Liz" wrote in message ... I need help with this if anyone can help me with this: A1=$1500 B1=$1500 I want to create a logic that if B1 is greater or equal to A1 then YES and if B1 is less than A1 then NO. And if the cells A1 or B1 is blank then the result cell should also appear blank and should not show #Value? or other values in the conditioned cell. What should I should to get this conditioned in one cell? Thanks Liz |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to use the conditions? - Liz
One way:
=CHOOSE(SIGN(B1-A1)+2,"NO","","YES") In article , Liz wrote: I need help with this if anyone can help me with this: A1=$1500 B1=$1500 I want to create a logic that if B1 is greater or equal to A1 then YES and if B1 is less than A1 then NO. And if the cells A1 or B1 is blank then the result cell should also appear blank and should not show #Value? or other values in the conditioned cell. What should I should to get this conditioned in one cell? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to use the conditions? - Liz
It worked thanks. I've another question...........
If A1 = 2/17/2007 B1 = 2/22/2007 I've cell C1 with a formula to calculate the difference between those dates and based on the result which appears on C1 I've a condition in cell D1 which is if C1 is greater or equal to 0 then YES and if less than 0 then NO. But I need one more condition that is if c1 is has no value which is when the A1 and B1 is blank I need the D1 cell to appear blank to but should have the condition in place. PS: I've formatted the C column by unchecking the zero values under Tools/Options/View. Thanks Liz "Philip Trick" wrote: This formula should work: =IF(OR(A1="",B1=""), "", IF(B1 = A1, "YES", "NO")) If A1 or B1 is blank, return a blank, otherwise if B1 is greater or equal than A1 return Yes, otherwise return No. -- Philip Trick Actuarial Consultant "Liz" wrote: I need help with this if anyone can help me with this: A1=$1500 B1=$1500 I want to create a logic that if B1 is greater or equal to A1 then YES and if B1 is less than A1 then NO. And if the cells A1 or B1 is blank then the result cell should also appear blank and should not show #Value? or other values in the conditioned cell. What should I should to get this conditioned in one cell? Thanks Liz |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to use the conditions? - Liz
One way:
D1: =C1 Select column D. Choose Format/Cells/Number/Custom "YES";"NO";; In article , Liz wrote: It worked thanks. I've another question........... If A1 = 2/17/2007 B1 = 2/22/2007 I've cell C1 with a formula to calculate the difference between those dates and based on the result which appears on C1 I've a condition in cell D1 which is if C1 is greater or equal to 0 then YES and if less than 0 then NO. But I need one more condition that is if c1 is has no value which is when the A1 and B1 is blank I need the D1 cell to appear blank to but should have the condition in place. PS: I've formatted the C column by unchecking the zero values under Tools/Options/View. Thanks Liz "Philip Trick" wrote: This formula should work: =IF(OR(A1="",B1=""), "", IF(B1 = A1, "YES", "NO")) If A1 or B1 is blank, return a blank, otherwise if B1 is greater or equal than A1 return Yes, otherwise return No. -- Philip Trick Actuarial Consultant "Liz" wrote: I need help with this if anyone can help me with this: A1=$1500 B1=$1500 I want to create a logic that if B1 is greater or equal to A1 then YES and if B1 is less than A1 then NO. And if the cells A1 or B1 is blank then the result cell should also appear blank and should not show #Value? or other values in the conditioned cell. What should I should to get this conditioned in one cell? Thanks Liz |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to use the conditions? - Liz
Very neat solution, JE.
-- Regards Roger Govier "JE McGimpsey" wrote in message ... One way: =CHOOSE(SIGN(B1-A1)+2,"NO","","YES") In article , Liz wrote: I need help with this if anyone can help me with this: A1=$1500 B1=$1500 I want to create a logic that if B1 is greater or equal to A1 then YES and if B1 is less than A1 then NO. And if the cells A1 or B1 is blank then the result cell should also appear blank and should not show #Value? or other values in the conditioned cell. What should I should to get this conditioned in one cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Sum if 2 conditions are met | Excel Worksheet Functions | |||
Conditions Help | Excel Worksheet Functions | |||
SUM 2 Conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |