Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - AND Function
Hi Folks - I'm trying to create an IF/AND function something like this ....
=if(and(a1="RI", c1="Sold"),"Property Sold", "For Sale") Basically, if State = RI AND Status = Sold, then display appropriate text. However, it seems that the AND function does not handle text as a logical test. Any workarounds? Thanks, Michael |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - AND Function
Your formula is correct except that you want to add something if both cells
are empty, so I suspect that you might have hidden spaces. Does this work? =IF(AND(TRIM(A1)="RI", TRIM(C1)="Sold"),"Property Sold", "For Sale") if so you have extra spaces, if it still doesn't work you might have hidden html characters or there is a typo somewhere -- Regards, Peo Sjoblom "Michael" wrote in message ... Hi Folks - I'm trying to create an IF/AND function something like this .... =if(and(a1="RI", c1="Sold"),"Property Sold", "For Sale") Basically, if State = RI AND Status = Sold, then display appropriate text. However, it seems that the AND function does not handle text as a logical test. Any workarounds? Thanks, Michael |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - AND Function
Yep .... there were stray spaces ..... Thanks.
Michael "Peo Sjoblom" wrote in message ... Your formula is correct except that you want to add something if both cells are empty, so I suspect that you might have hidden spaces. Does this work? =IF(AND(TRIM(A1)="RI", TRIM(C1)="Sold"),"Property Sold", "For Sale") if so you have extra spaces, if it still doesn't work you might have hidden html characters or there is a typo somewhere -- Regards, Peo Sjoblom "Michael" wrote in message ... Hi Folks - I'm trying to create an IF/AND function something like this .... =if(and(a1="RI", c1="Sold"),"Property Sold", "For Sale") Basically, if State = RI AND Status = Sold, then display appropriate text. However, it seems that the AND function does not handle text as a logical test. Any workarounds? Thanks, Michael |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - AND Function
Should have been "you might want to add something"
-- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... Your formula is correct except that you want to add something if both cells are empty, so I suspect that you might have hidden spaces. Does this work? =IF(AND(TRIM(A1)="RI", TRIM(C1)="Sold"),"Property Sold", "For Sale") if so you have extra spaces, if it still doesn't work you might have hidden html characters or there is a typo somewhere -- Regards, Peo Sjoblom "Michael" wrote in message ... Hi Folks - I'm trying to create an IF/AND function something like this .... =if(and(a1="RI", c1="Sold"),"Property Sold", "For Sale") Basically, if State = RI AND Status = Sold, then display appropriate text. However, it seems that the AND function does not handle text as a logical test. Any workarounds? Thanks, Michael |
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 |