Thanks:  0
Likes:  0

# Thread: How to insert a blank value with a function

1. If I understand your intent correctly (I was/am quite unsure about MJ's), wouldn't just

=VLOOKUP(E2,R2:S12,2,FALSE)

suffice?
Not necessarily... what if R2:R12 contains a 0?
[/quote]

There's no 0's in R2:S12; it is a fixed vocabulary that is then translated to a fixed list of numbers starting at 1.0.

The simplest =VLOOKUP thus suffices! I didn't realize #N/A let's the chart interpolate that value without explicetly being told to, this is way better than my previous hacks. I thin kI discarded my first attempt with a simple VLOOKUP because I didn't like the look of all the #N/A's in the set and assumed it would cause errors in the chart. But as the column is hidden anyway, this is actually absolutely perfect.

Thanks!

2. Whoops, last post was of course me...

3. Not necessarily... what if R2:R12 contains a 0?
Mark, if R2:R12 did have a 0, wouldn't be "necesary" to plot it ? I mean, the data IS there, then, it should be plotted... not ?

4. MJ,

Quel denoument!

I didn't dare to think that you just wanted to suppress 0-values from your charts. Mark has gone straight to that conclusion. Looks like rightly so.

On 2002-02-26 07:58, Anonymous wrote:
If I understand your intent correctly (I was/am quite unsure about MJ's), wouldn't just

=VLOOKUP(E2,R2:S12,2,FALSE)

suffice?
Not necessarily... what if R2:R12 contains a 0?
There's no 0's in R2:S12; it is a fixed vocabulary that is then translated to a fixed list of numbers starting at 1.0.

The simplest =VLOOKUP thus suffices! I didn't realize #N/A let's the chart interpolate that value without explicetly being told to, this is way better than my previous hacks. I thin kI discarded my first attempt with a simple VLOOKUP because I didn't like the look of all the #N/A's in the set and assumed it would cause errors in the chart. But as the column is hidden anyway, this is actually absolutely perfect.

Thanks!
[/quote]

5. ## Re: How to insert a blank value with a function

F16= Start date
G16= End Date

=NETWORKDAYS(F16,IF(ISBLANK(G16),TODAY(),G16))

If you end date is blank (they are still working for you) then it will give the number of days that they have worked between their start day and the current date.

6. ## Re: How to insert a blank value with a function

Welcome to the Board!

Originally Posted by Gra06021
F16= Start date
G16= End Date

=NETWORKDAYS(F16,IF(ISBLANK(G16),TODAY(),G16))

If you end date is blank (they are still working for you) then it will give the number of days that they have worked between their start day and the current date.

7. ## Re: How to insert a blank value with a function

Whoops! yes this went to the wrong thread!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•