IF AND Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nabanco - 16 Jun 2007 20:20 GMT

Hello,

Any suggestions on how to set up a formula for the below problem:

In once cell I'd like to return if true "Underwrite Now", and if false
return "Don't Worry"

Cell A1, if between 7 and 100, then return true

OR

if cell A2 is between 2 and 100, return true

Thank you

Reply to this Message

Bob Phillips - 16 Jun 2007 20:28 GMT

=IF(OR(AND(A1>=7,A1<=100),AND(A2>=2,A2<=100)),"Underwrite Now","Don't
Worry")

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hello,
>
[quoted text clipped - 10 lines]
>
> Thank you

Reply to this Message

nabanco - 16 Jun 2007 20:46 GMT

You are the man, been working on that for some time now!

Thanks for helping my headache

> =IF(OR(AND(A1>=7,A1<=100),AND(A2>=2,A2<=100)),"Underwrite Now","Don't
> Worry")
[quoted text clipped - 13 lines]
> >
> > Thank you

Reply to this Message