View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave[_45_] Dave[_45_] is offline
external usenet poster
 
Posts: 1
Default Programming worksheet

I have set up a Rota for various staff within Excel there
is a worksheet for each department. I also have a
Holiday Sheet set up so if you enter H in any cell on the
Rota it will automatically transfer to Holiday sheet. I
have done this using the IF function.

I now want to extend this to Using S for Sickness M for
maternity etc but if i try using multiple entries of IF
function i just keep getting error.


Any Suggestions?