Some help with a function code

[BryanNeff]

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.

[horst]

Hi @BryanNeff, 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.

[BryanNeff]

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.