Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

I am trying to make a variable of the column or row in

in other words I have a formula   if(tab4.a6>0, tab4.a6,"") this formula is entered into cell g12 in tab3 ( a tab different from tab 4)

now it turns out that tab4 has a long list of entries which I want, but each one is in the same column but a different row,, further
there are many  empty rows between values in tab4.a

what i want to do is to be able to put the column entry in g1 of tab 3..and make the

have the if(tab4.a(g1)>0, tab4ag1, "")  so that I can tell the cell in which the formula is entered to grab the value from tab4.a < that I tell it to, but manually entering the row of column a in tab4 that I want..

row value g1 = 3                         row value g1 = 240          and so on.

formula in cell changes to          formula in cell changes to

if(tab4.a3>0,tab4.a3,"") if(tab4.a240>0,tab4.a240,"")

Is there a way to do this

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.