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.) > This formula returns 'TRUE': =IF(COUNTIF(A1:A5000;D1)OR(COUNTIF(A1:A5000;E1))) Yep, I'm definitely not getting what you're asking for. _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
