Simple Public Function? Have the formula = the value in the cell 1 to the left

[MNpoker]

I want to write a public function where the value is the cell one to the left.

Help!

Actually it's a bit more than that but I think that would get me there.
It's really the next cell with a value above the cell one to the left / the value one cell to the left

Thanks!

 

[GlennUK]

... the next cell with a value above the cell one to the left ...

can you explain the above more clearly please?

 

[MNpoker]

can you explain the above more clearly please?

Say I put = Publicfunction1() in cell B5



First find the value in A5 (this is the denominator)

If there is a value in A4 then that value is the numerator if not
If there is a value in A3 then that value is the numerator if not
.......................

And so on.

 

[DonkeyOte]

to clarify... you mean in non-VBA terms something like the below (posted into C7)

=IF(OR(ROW(C7)=1,COLUMN(C7)=1),-1,LOOKUP(9.99999999999999E+307,OFFSET(C7,1-ROW(C7),-1):OFFSET(C7,-1,-1))/OFFSET(C7,0,-1))

 

[Richard Schollar]

Function CellToLeft()
CellToLeft = Application.Caller.Offset(, -1).Value
End Function

No idea why you'd want this though