Ask Your Question
0

How do I refer to a cell, address from ROW and COLUMN functions

asked 2015-07-20 20:39:05 +0100

ask libreoffice gravatar image

In my IF I want to know, if the topmost field of my fields column matches with the value of the leftmost field of my fields row.

if ( cellref(COLUMN(),1)=cellref(1,ROW()) ; myexpression ; otherexpression )

What function do I have to use, or how can I sole my problem? Thanks for your help!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2015-07-20 22:49:59 +0100

m.a.riosv gravatar image

There are at least three functions than can help with your problem:

INDEX() OFFSET() INDIRECT(ADDRESS())

edit flag offensive delete link more
-1

answered 2015-07-30 03:26:46 +0100

very simple : you just set (for example if the cells are c4 and h9) if ( c4=h9 ; yourexpression ; otherexpression ) or if you prefer if ( $c$4=$h$9 ; yourexpression ; otherexpression)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-07-20 20:39:05 +0100

Seen: 463 times

Last updated: Jul 30 '15