[PLUG] Open Office Calc

[Russell Johnson]

On Oct 18, 2012, at 4:28 PM, Aaron Burt <aaron at bavariati.org> wrote:

> On Thu, Oct 18, 2012 at 01:57:00PM -0700, Russell Johnson wrote:
>> I have a sheet with 4 columns. What I need is a formula that will compare
>> the value in column 3 and 4 to column 1, and return the value in column 2
>> in the same row as column 1. 
> 
> Don't think I quite get what you're asking for, but here's a go:
> =if(or(A2>C2,A2>D2),B2,0)
> which does this:
> If column 1 is greater than column 3 or 4, return the value in column 2.
> Otherwise, return 0.
> (Note: I'm assuming there's a header in row 1.)

Thanks for trying. :)

It would be something like this:

If the value in B3 or the value in B4 exists in column 1, return the value in ?2 where ? is the row in column A where the value was found.

Russell Johnson
russ at dimstar.net