[libreoffice-users] how do i in calc

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: users+unsubscribe@global.libreoffice.org
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