| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with IF function
On Tuesday, August 26, 2008 at 4:18:00 AM UTC+2, Michelle wrote:
Am trying to create a formula that will tell me: if the range of cells has the single letter "R" or the single letter "T" in the individuals cells, it will return the word "Pass", or otherwise will return the word "Fail". Thanks, -- Michelle IF(A1:A20< 10,"FAIL,"PASS") What is wrong with this formula? Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
