Formula Assistance

**Dawn V** · 03-31-2008, 09:04 AM

Good morning!

I'm not sure how to fix this formula. It's a error stating "text". How do I fix this? I tried the help option, but it wasn't much help.

The cell is: T8 & U8

=IF(S8="","",NETWORKDAYS(R8,S8))
=IF(T8="","",IF(T8>7,"N","Y"))

**StephenR** · 03-31-2008, 09:15 AM

Wow. Perhaps you need to attach your workbook. Nobody here is psychic!

**NBVC** · 03-31-2008, 09:23 AM

Originally Posted by Dawn V

Good morning!

I'm not sure how to fix this formula. It's a error stating "text". How do I fix this? I tried the help option, but it wasn't much help.

The cell is: T8 & U8

=IF(S8="","",NETWORKDAYS(R8,S8))
=IF(T8="","",IF(T8>7,"N","Y"))

I'm having difficulty uploading the file.

Is the error "text" or "#NAME?"....

Maybe you need to activate your Analysis Toolpak Addin.

Go to Tools|Addins and select Analysis Toolpak...you may need your original CDs

**Dawn V** · 03-31-2008, 09:38 AM

This is what it is showing me...
Correct a #NAME? error
Occurs when Microsoft Excel doesn't recognize text in a formula.

Click the cell that displays the error, click the button that appears , and then click Trace Error if it appears.

Review the possible causes and solutions.

Possible causes and solutions
Using a function that is part of the Analysis Toolpak add-in, without the add-in being loaded

Install and load the Analysis Toolpak add-in.

How?

On the Tools menu, click Add-Ins.

In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.

If necessary, follow the instructions in the setup program.

Using a name that does not exist

Make sure the name exists. On the Insert menu, point to Name, and then click Define. If the name is not listed, add the name by using the Define command.

Misspelling the name

Verify the spelling. Select the name in the formula bar , press F3, click the name you want to use, and then click OK.
Using a label in a formula, without labels being allowed

Allow labels to be used. On the Tools menu, click Options, and then click the Calculation tab. Under Workbook options, select the Accept labels in formulas check box.

Misspelling the name of a function

Correct the spelling. Insert the correct function name into the formula by clicking Function on the Insert menu.
Entering text in a formula without enclosing the text in double quotation marks

(Excel tries to interpret your entry as a name even though you intended it to be used as text.)

Enclose text in the formula in double quotation marks. For example, the following formula joins the piece of text "The total amount is " with the value in cell B50:
="The total amount is "&B50

Omitting a colon (

in a range reference

Make sure all range references in the formula use a colon (

; for example, SUM(A1:C10).

Referencing another sheet not enclosed in single quotation marks

If the formula refers to values or cells on other worksheets or workbooks and the name of the other workbook or worksheet contains a nonalphabetical character or a space, you must enclose its name within single quotation marks ( ' ).

**EdMac** · 03-31-2008, 09:45 AM

The formulae are correct, so the problem must be in the data being evaluated. Are the source cells really dates or numbers or are they text?

Have you tried using the formula auditing tools?

**NBVC** · 03-31-2008, 09:52 AM

Originally Posted by NBVC

Is the error "text" or "#NAME?"....

Maybe you need to activate your Analysis Toolpak Addin.

Go to Tools|Addins and select Analysis Toolpak...you may need your original CDs

The Networkdays() function is an analysis toolpak addin function. Excel won't recognize it until you have installed the analysis toolpak...

see my previous post.

**Dawn V** · 03-31-2008, 09:55 AM

I checked and they are listed as date formats. I'm not sure what auditing tools are.

**Dawn V** · 03-31-2008, 09:56 AM

Can you recommend another way to redue the formula?

**EdMac** · 03-31-2008, 10:13 AM

As NBVC says - you need the analysis TOOLPACK to use NETWORKDAYS.

Have you tried following the instructions you quoted?

On the Tools menu, click Add-Ins.

In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.

Auditing tools are available from TOOLS > Formula auditing > Evaluate formula.

**Dawn V** · 03-31-2008, 10:23 AM

WOW.... I never knew that option was there! When it was recommended, I wasn't quite understanding. Thank you all SOOOOOO much for your help! I appreciate it more than words can express!