[libreoffice-users] Help with Conditional Macro Please.

Hi,
I need a macro to insert a nominal code which depends on the value in a 
cell.  This is to follow the text contents of two other cells (names) 
and the date contents of two more cells.  The end result will be in one 
cell with comma separating giving:-

Name1,name2, date1-date2, nominal code


If cell value is 2, then nominal code is 4601
If cell value is 4, then nominal code is 4502
If cell value is 6, then nominal code is 4503
If cell value is 8, then nominal code is 4501

I am working on the easier bits but if anybody has time to help it would 
be much appreciated.

Budgie

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted