Hi

I have the following in a row.


6.50 6.60 6.70 6.95
In the last cell I want to put in an IF statement to check the entire row
whether there is a value of less than 6.50 and return MW, if not then return
OK.

May be just basic, but cannot get it to work. Any help would be appreciated.

Thanks
Tony

Try = IF(countif(a1:a4,"<="&6.50),"MW","OK")

Adapt the range to your needs

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer

Thanks for your reply.
I did Tried this but it is saying MW to a value of 6.60
-6.60 --MW

Any suggestions, thanks

Please post a sample sheet. It could be that you have some text looking like numbers

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here we go attached herewith, thanks again.

Attached Files

If st 05 03 15.xlsx (8.8 KB, 7 views)

Pecoflyer, I have just figured it out. It is taking 0 as a value below 6.50, and is why the formula was not working. Just deleted the 0 from celss & it started working fine.

Many thanks for your help, regards, Tony

You're welcome

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post