Thread: How to assign numbers to letters and then create a formula to add them together for a rota
View Single Post
 
Old 03-30-2017, 03:50 PM
Mskapri Mskapri is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Mar 2017
Posts: 4
Mskapri is on a distinguished road
Default
xor, thank you for your reply. I have tried the formula that you've suggested but I can't get it to work.

The A and L should be together as this is the code used for Annual Leave and it should equal 7.4. I sort of understand how the formula works but can you please explain why there are semi colons in the last bit instead of commas?

Thanks again for your reply, I will look at it again tomorrow as it's almost midnight and I have an early start :-(
Reply With Quote