Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How to assign numbers to letters and then create a formula to add them together for a rota
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 03-30-2017, 03:50 PM
Mskapri Mskapri is offline How to assign numbers to letters and then create a formula to add them together for a rota Windows 7 32bit How to assign numbers to letters and then create a formula to add them together for a rota Office 2010 32bit
Novice
How to assign numbers to letters and then create a formula to add them together for a rota 		 
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
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Swapping column and row formats. Letters to numbers etc. AdamNT69 Excel 2 10-17-2016 08:44 AM
How to assign numbers to letters and then create a formula to add them together for a rota more symbols for super/subscript numbers and letters djc Word 5 03-13-2015 10:54 AM
How to assign numbers to letters and then create a formula to add them together for a rota Captions mixing letters and numbers trew Word 7 11-21-2012 12:54 AM
How to assign numbers to letters and then create a formula to add them together for a rota Creating TOC with letters and numbers tanababa Word 1 04-28-2011 01:35 AM
mailmerge with letters of a different numbers of pages roel1972 Mail Merge 0 02-21-2011 11:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:15 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft