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

On 26/10/14 16:46, Brian Barker wrote:
> 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
Hi Brian,
OK, looks simpler and though I would give it a try but having loaded my 
.csv file none of the formula are working.  Is there somewhere these can 
be turned on and off?
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