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: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
