| 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 | |||
Linear Mode
