Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
HELP, I have a If function comparing 2 cells of data, but want the result to
return a blank cell if one of the two cells being compared is blank. Example Cell C1 is "L" Cell D1 is "M" The formula I have in would return "X" for wrong, if D1 was "L", then my result would return "c" - but I would also like if D1 was blank with no data, the result would also be blank |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
Sorry, I missed that you want a "c" if they match. That formula would be:
=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",IF(A1=B1,"c","X ")) -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "JBeaucaire" wrote: Maybe something like this comparing A1 and B1: =IF(OR(ISBLANK(A1),ISBLANK(B1),A1=B1),"","X") -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "FrankM" wrote: HELP, I have a If function comparing 2 cells of data, but want the result to return a blank cell if one of the two cells being compared is blank. Example Cell C1 is "L" Cell D1 is "M" The formula I have in would return "X" for wrong, if D1 was "L", then my result would return "c" - but I would also like if D1 was blank with no data, the result would also be blank |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function
Maybe something like this comparing A1 and B1:
=IF(OR(ISBLANK(A1),ISBLANK(B1),A1=B1),"","X") -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "FrankM" wrote: HELP, I have a If function comparing 2 cells of data, but want the result to return a blank cell if one of the two cells being compared is blank. Example Cell C1 is "L" Cell D1 is "M" The formula I have in would return "X" for wrong, if D1 was "L", then my result would return "c" - but I would also like if D1 was blank with no data, the result would also be blank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
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 |