Previous Topic Next Topic

Less than/greater than

Closed
Gus1 Posts 1 Registration date Tuesday 22 July 2014 Status Member Last seen 22 July 2014 - 22 Jul 2014 à 12:28
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 22 Jul 2014 à 14:19
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

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
22 Jul 2014 à 14:19
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