| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula For If & Or Condition
Hi, I am having a column with different values in different cells. I want to populate the adjacent cell with either blank or a value for eg."Found". So if the cell has the values "A" or "B" then populate the adjacent cell with blank else if the values or anything other than "A" and "B" then populate it with "Found". I tried this formula IF(E7<"A",IF(E7<"B","FOUND","")), but this does not work. Could somebody help me with this formula. Thanks & REgards Anand -- anandmr65 ------------------------------------------------------------------------ anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728 View this thread: http://www.excelforum.com/showthread...hreadid=533366 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula and Condition for a Calculation to leave a zero if the res | Excel Worksheet Functions | |||
| Can I set up a formula to lookup a value for a condition | Excel Discussion (Misc queries) | |||
| Multiple Condition Formula | Excel Worksheet Functions | |||
| Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
| Add condition to formula | Excel Worksheet Functions | |||
Threaded Mode
