View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kirsty_H Kirsty_H is offline
external usenet poster
 
Posts: 1
Default 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).