Using two formulae

[Kirsty_H]

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

 

[Bernie Deitrick]

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

 

[Spiky]

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

 

[Kirsty_H]

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!