Re: [libreoffice-users] Help with Conditional Macro Please.

At 15:09 26/10/2014 +0000, Alastair Noname wrote:
> 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

Could you not simply create a table of values with 2, 4, 6, and 8 in 
one column and 4601 etc. in the other and then use VLOOKUP() in a 
function to extract what you need? I don't see why a macro would be necessary.

I trust this helps.

Brian Barker


--
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