| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function issues w/ empty cells
On Thu, 1 Jan 2009 11:59:01 -0800, Bri
wrote: 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 Assuming your data are all non negative integers, try this formula: =LOOKUP(A1,{0,4,10},{0,1,2}) Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function issues w/ empty cells
Hi,
Here is a standard IF approach =IF(A19,2,IF(A13,1,0)) Note your post does not address negative numbers, but here they are teated the same as 0. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Bri" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
