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).

Using two formulae
 

Kirsty,

What do you want to do with the two formulas? Add the results?

=IF(A50="",260,NETWORKDAYS($B$4,A50)) + IF(B50="",260,260-NETWORKDAYS($B$4,B50))

Display the results with some words?

="Column A: " & IF(A50="",260,NETWORKDAYS($B$4,A50)) & ", Column B: " &
IF(B50="",260,260-NETWORKDAYS($B$4,B50))


HTH,
Bernie
MS Excel MVP


"Kirsty_H" wrote in message
...
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).

Using two formulae
 

On Aug 6, 10:19 am, Kirsty_H
wrote:
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).

I think you may be looking for this:
=IF(AND(A50="",B50=""),260,NETWORKDAYS($B$4,A50))

Using two formulae
 

"Spiky" wrote:

On Aug 6, 10:19 am, Kirsty_H
wrote:
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).

I think you may be looking for this:
=IF(AND(A50="",B50=""),260,NETWORKDAYS($B$4,A50))


That is definitely bringing me closer to what I am trying to do, thank you!