Ask Your Question
0

Some help with a function code [closed]

asked 2014-03-06 15:41:09 +0100

Bryan Neff gravatar image

Hey everyone. I'm trying to learn how to use LibreOffice a bit better, and also need some coding for something I'm working on.

Basically what I'm hoping for is a...

If a cell in Column A has X in it, then insert "text" with the value of the information in the cell of Column B and C that is in the SAME ROW at specified points...

An example may help:

Right now, it looks like |TBA |2 |4 |

With TBA in column A, 2 in B, and 4 and C.

I want a formula that will see that Column A has TBA, and change it to : Tap Break-in Active from 2 to 4 o'clock.

The value of column B and C changes with every row, so it should only apply to the cell that's in the same row.

If this doesn't make sense, I'll explain more.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 06:10:23.458646

1 Answer

Sort by » oldest newest most voted
0

answered 2014-03-07 17:03:23 +0100

horst gravatar image

Hi @Bryan Neff, here is what you have to do:

in Column D1, first occurance of "TBA.." you write (every thing after the colon):

="Tap Break-in Active from "&B1&" to "&C1&" o'clock."

Now you copy this cell down as far as you need it. Every time you enter your data in a new row you will have your result in column D.

edit flag offensive delete link more

Comments

Thank you very much! After a good deal of work, I came up with something similar... Then another guy in the office came up with a brilliant program that does this for all the various damage codes we have. But thank you for confirming! It's a good help to know I did it right.

Bryan Neff gravatar imageBryan Neff ( 2014-03-07 17:33:08 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-03-06 15:41:09 +0100

Seen: 45 times

Last updated: Mar 07 '14