compare 3 cells

[phillyd023]

Good morning,

i am sure this is relatively easy but i can't seem to wrap my mind around how to get it done.

I am have 3 cells that i want to compare (A1,B1 and C1). by default al cell values are 0. what i need to know is if any 2 of the cells (or all 3) are both greater than 0. This could be as easy as the result being true or false.

The reasoning for this is that at any time on my spreadsheet there can only be one of the cells with a value greater than 0. if multiple cells are greater than 0 then i have a problem to look into and this formula will tell me.

thanks

[Pepe Le Mokko]

Try

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Try this

=countIf(A1:C1,">0")>1

[phillyd023]

Thanks! i tried the =IF(COUNTIF(A1:C1,">0")>=2,"Incorrect","OK") and it worked.