Formula to check two cells greater than one other cell

**FIFTYFINGERS** · 11-23-2012, 02:35 PM

I am using this formula to track people who are lowering their blood pressure by systolic number, over three cells in the same row
(H2-1st#,N2-2nd#,T2-3rd#). My problem is, if both N2 and T2 are not less than H2 i do not get a "1" for the answer. i need the formula to give me a "1" if either one (N2,T2) or both are less than H2.

Thanks, in advance for your help.

**Steve N.** · 11-23-2012, 02:48 PM

Without seeing a sample worksheet I can only guess at what you're working with. Will this work for you?

=IF(OR($T2<$H2,$N2<$H2),"1","0")

**FIFTYFINGERS** · 11-23-2012, 02:50 PM

Thanks Steve! it looks like it worked.

**Marcol** · 11-23-2012, 03:03 PM

Try using OR() rather than AND(), why are your numbers 0 & 1 in quotes? Do you want text returned?

This returns numbers ...

Formula:

Please Login or Register  to view this content.

Formula to check two cells greater than one other cell

LinkBack

Thread Tools

Rate This Thread

Display

Formula to check two cells greater than one other cell

Re: i am using =IF(AND($H2>$N2,$H2>$T2),"1","0") i need "1" if either one (N2,T2) or both

Re: i am using =IF(AND($H2>$N2,$H2>$T2),"1","0") i need "1" if either one (N2,T2) or both

Re: Formula to check two cells greater than one other cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions