| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I combine If and AND Formula
I want to use a IF Formula but need to combine it with an AND Formula as I am
trying to check if the value of a cell is between two values...in my case If cell is between 12 and 24 show "X". I came so far as =If(A1=12;"X";"") so now I need to get it also to check if A1 is smaller than 24. How can I do that? Regards Nicole |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine If and AND Formula
Fixed it...thanks.
"Nicole" wrote: I want to use a IF Formula but need to combine it with an AND Formula as I am trying to check if the value of a cell is between two values...in my case If cell is between 12 and 24 show "X". I came so far as =If(A1=12;"X";"") so now I need to get it also to check if A1 is smaller than 24. How can I do that? Regards Nicole |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine If and AND Formula
Use the AND function
=IF(AND(A1=12,A1<24),"X","") or perhaps you meant =IF(AND(A1=12,A1<=24),"X","") Tyro "Nicole" wrote in message ... I want to use a IF Formula but need to combine it with an AND Formula as I am trying to check if the value of a cell is between two values...in my case If cell is between 12 and 24 show "X". I came so far as =If(A1=12;"X";"") so now I need to get it also to check if A1 is smaller than 24. How can I do that? Regards Nicole |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine If and AND Formula
Use the AND function
=IF(AND(A1=12,A1<24),"X","") or perhaps you meant =IF(AND(A1=12,A1<=24),"X","") If she meant the latter one, it's possible to have a formula without even using the AND function... =IF(ABS(A1-18)<=6,"X","") Rick |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine If and AND Formula
Obfuscation is a grand thing. I remember when we wrote entire C programs on
one line. Let's keep it simple Tyro "Rick Rothstein (MVP - VB)" wrote in message ... Use the AND function =IF(AND(A1=12,A1<24),"X","") or perhaps you meant =IF(AND(A1=12,A1<=24),"X","") If she meant the latter one, it's possible to have a formula without even using the AND function... =IF(ABS(A1-18)<=6,"X","") Rick |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I combine If and AND Formula
<<<"Let's keep it simple"
Why? Don't forget ... these groups are not just for the OPs. They're part of an educational process for anyone interested in XL, plus they add to the archives. Once the OPs have their uncomplicated, lucid suggestions, what comes beyond that can be enjoyable and entertaining, not to mention didactic, and pedagogical to the "more informed". -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Tyro" wrote in message ... Obfuscation is a grand thing. I remember when we wrote entire C programs on one line. Let's keep it simple Tyro "Rick Rothstein (MVP - VB)" wrote in message ... Use the AND function =IF(AND(A1=12,A1<24),"X","") or perhaps you meant =IF(AND(A1=12,A1<=24),"X","") If she meant the latter one, it's possible to have a formula without even using the AND function... =IF(ABS(A1-18)<=6,"X","") Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine a symbol and a formula | Excel Worksheet Functions | |||
| How do I combine an if and min formula? | Excel Worksheet Functions | |||
| Formula to combine text? | Excel Worksheet Functions | |||
| Combine VLOOKUP, IF, AND in one formula | Excel Worksheet Functions | |||
| formula to combine cells using if/then | Excel Worksheet Functions | |||
Linear Mode
