| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND with value between a range
If need help on a formula that will return "not okay"for the following
condition: If col B cell J679 AND col A is BETWEEN 1.65 and 1.99 then "not okay", otherwise "" col A col B cellJ679 = 12 row 1 1.42 7 row 2 1.68 15 row 3 1.80 12 row 4 2.0 24 thank you in advance! jane |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND with value between a range
Try this:
=IF(AND(A1=1.65,A1<=1.99,B1J679),"not okay","") -- Biff Microsoft Excel MVP "Jane" wrote in message ... If need help on a formula that will return "not okay"for the following condition: If col B cell J679 AND col A is BETWEEN 1.65 and 1.99 then "not okay", otherwise "" col A col B cellJ679 = 12 row 1 1.42 7 row 2 1.68 15 row 3 1.80 12 row 4 2.0 24 thank you in advance! jane |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND with value between a range
=IF(AND(B1J679,A1=1.65,A1<=1.99),"not okay","")
"Jane" wrote: If need help on a formula that will return "not okay"for the following condition: If col B cell J679 AND col A is BETWEEN 1.65 and 1.99 then "not okay", otherwise "" col A col B cellJ679 = 12 row 1 1.42 7 row 2 1.68 15 row 3 1.80 12 row 4 2.0 24 thank you in advance! jane |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND with value between a range
ah of course!
I made it much harder than it needed to be. thank you! "T. Valko" wrote: Try this: =IF(AND(A1=1.65,A1<=1.99,B1J679),"not okay","") -- Biff Microsoft Excel MVP "Jane" wrote in message ... If need help on a formula that will return "not okay"for the following condition: If col B cell J679 AND col A is BETWEEN 1.65 and 1.99 then "not okay", otherwise "" col A col B cellJ679 = 12 row 1 1.42 7 row 2 1.68 15 row 3 1.80 12 row 4 2.0 24 thank you in advance! jane |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND with value between a range
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Jane" wrote in message ... ah of course! I made it much harder than it needed to be. thank you! "T. Valko" wrote: Try this: =IF(AND(A1=1.65,A1<=1.99,B1J679),"not okay","") -- Biff Microsoft Excel MVP "Jane" wrote in message ... If need help on a formula that will return "not okay"for the following condition: If col B cell J679 AND col A is BETWEEN 1.65 and 1.99 then "not okay", otherwise "" col A col B cellJ679 = 12 row 1 1.42 7 row 2 1.68 15 row 3 1.80 12 row 4 2.0 24 thank you in advance! jane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Linear Mode
