| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use the search in an if statement
I have a spreadsheet with numbers in column B and letters in column C. I
need to search for "J" in Column C and if there is not a J there and there is a number 0 in Column B, I need to put a "B" in Column D. I figured out the search function, but when there is not a J, I am just getting an error, what formula should can I use? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with solving this if statement which uses a search for text s | Excel Discussion (Misc queries) | |||
| Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
| If then statement to search for text possible? | Excel Discussion (Misc queries) | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
Threaded Mode
