How can I set the criterion 'if the cell is at the right of a specific cell' ?

[excelos]

hello!

How can I set the criterion 'if the cell is at the right of a specific cell' ?
Or if the column of the cell is higher than a letter etc?

Thanks!

 

[Joe4]

You can use the column function to return the column number of the cell the formula is contained in.
For example, try entering this formula in any cell:
=COLUMN()

That should allow you to do whatever it is that you want.

 

[excelos]

thanks but I am still having problems

this formula puts D121 offsetted by a number
it ignores text cells but it returns some texts that have numbers, which I don't
basically I want to consider anything at the left of D121 as 0,

any hint?


[]=IFERROR(IF(AND(ISNUMBER(OFFSET(D121,0,-($L$6))),(COLUMN(D121))>3),OFFSET(D121,0,-($L$6)),0),0)[]

 

[Joe4]

What is in L6?