Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND Function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND Function
=IF(OR(AND(A1=7,A1<=100),AND(A2=2,A2<=100)),"Und erwrite Now","Don't
Worry") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "nabanco" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND Function
You are the man, been working on that for some time now!
Thanks for helping my headache "Bob Phillips" wrote: =IF(OR(AND(A1=7,A1<=100),AND(A2=2,A2<=100)),"Und erwrite Now","Don't Worry") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "nabanco" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |