Previous Topic Next Topic

Less than/greater than

Closed
Gus1 Posts 1 Registration date Tuesday July 22, 2014 Status Member Last seen July 22, 2014 - Jul 22, 2014 at 12:28 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 22, 2014 at 02:19 PM
I need a formula that will allow me to show if any cells in a range have a greater value than 100,if so show "YES". If not, have cell remain blank.
I have used =IF(B6:E6>=100,"YES"," ")as well as several others and the only thing it allows me to do is show the value of 1 cell at a time.

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 22, 2014 at 02:19 PM
Gus1, Good afternoon.

Try to use it:
= IF( COUNTIF(B6:E6 , ">=100" ) , "Yes" , "Nothing" )

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0