| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help me with a formula
if anything is in cell A1 AND in cell B1 then show "ab" in cell C1 if anything is in cell A1 and NOT in cell B1 then show "a" in cell C1 if nothing is in cell A1 and IS in cell B1 then show "b" in cell C1 if nothing is in either cell A1 or B1 then show "ab" in cell C1 Whats the formala I need to put in C1 to make the above rules work? Thankinoo. AJ -- Smeeg ------------------------------------------------------------------------ Smeeg's Profile: http://www.excelforum.com/member.php...o&userid=29099 View this thread: http://www.excelforum.com/showthread...hreadid=488206 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
