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

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

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