How to use the conditions?

How to use the conditions? - Liz

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Liz - 16 Apr 2007 18:42 GMT

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

Reply to this Message

Philip Trick - 16 Apr 2007 18:48 GMT

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.

Signature

Philip Trick
Actuarial Consultant

> I need help with this if anyone can help me with this:
>
[quoted text clipped - 10 lines]
> Thanks
> Liz

Reply to this Message

Liz - 16 Apr 2007 21:20 GMT

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

> This formula should work:
>
[quoted text clipped - 17 lines]
> > Thanks
> > Liz

Reply to this Message

JE McGimpsey - 16 Apr 2007 21:38 GMT

One way:

D1: =C1

Select column D. Choose Format/Cells/Number/Custom "YES";"NO";;

> It worked thanks. I've another question...........
>
[quoted text clipped - 35 lines]
> > > Thanks
> > > Liz

Reply to this Message

Roger Govier - 16 Apr 2007 19:01 GMT

Hi Liz

Try
=IF(A1=B1,"",IF(B1>A1,"Yes","No"))

Signature

Regards

Roger Govier

>I need help with this if anyone can help me with this:
>
[quoted text clipped - 13 lines]
> Thanks
> Liz

Reply to this Message

JE McGimpsey - 16 Apr 2007 19:10 GMT

One way:

=CHOOSE(SIGN(B1-A1)+2,"NO","","YES")

> I need help with this if anyone can help me with this:
>
[quoted text clipped - 7 lines]
>
> What should I should to get this conditioned in one cell?

Reply to this Message

Roger Govier - 16 Apr 2007 22:04 GMT

Very neat solution, JE.

Signature

Regards

Roger Govier

> One way:
>
[quoted text clipped - 14 lines]
>>
>> What should I should to get this conditioned in one cell?

Reply to this Message