Posted to microsoft.public.excel.worksheet.functions

Kirsty_H

external usenet poster

Posts: 1

Using two formulae

I want to use two formulae within one cell.
=IF(A50="",260,NETWORKDAYS($B$4,A50)) and
IF(B50="",260,260-NETWORKDAYS($B$4,B50)) are the general formulae I am trying
to use. Can I tell excel to use the first formula and the second formula
together in one cell? (I am working out Number of Working Days using Start
Dates and Leave Dates).

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formulae: Paste value formulae after doing an average operation	Lim	Excel Discussion (Misc queries)	4	April 20th 08 07:31 PM
Help with formulae	Pivot Man[_2_]	Excel Discussion (Misc queries)	3	August 16th 07 06:16 AM
Formulae	Richard[_3_]	New Users to Excel	4	August 14th 07 02:41 PM
age formulae	Gerald	Excel Discussion (Misc queries)	10	April 11th 06 06:43 AM
Searching TEXT in formulae, rather than results of formulae	AndyE	Excel Worksheet Functions	1	July 15th 05 10:57 AM

All times are GMT +1. The time now is 10:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us