| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function issues w/ empty cells
I have data that needs to be converted and I've tried using excel help for
assistance. Example... - If cells contain #'s 9 - it needs to return a 2 - If cells contain #'s 3 and <10 - it needs to return a 1 - If cells contain #'s = 0 and <4 - it needs to return a 0 - If cells contain no data / empty - it needs to return a 0 Depending on how I write the formula which has included OR, ISBLANK & LOOKUP, I only manage to get parts of it to work. Any assistance would be greatly appreciated. Bri |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want the autofill/drag function to skip empty cells | Excel Discussion (Misc queries) | |||
| Dynamic Chart (OFFSET Function) plots empty cells. | Charts and Charting in Excel | |||
| the countA function is counting everything even empty cells | Excel Worksheet Functions | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
