Searching a Range for a number over 40

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a row of numbers that containing hours worked and I want to know if
any of them are over 40. What formula should I use to tell if there are any?
It seemed that an IF statement something like this would work.
=IF(A3:cc3>40,"yes","no") but I'm not sure what the proper syntax for the
range is. Because I get the error #VALUE!. Simple I'm sure, but I can't
find it in Help. Annem
 
Hi Annem

One option
=IF(COUNTIF(A3:CC3,">40"),"yes","no")

--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au
 
Works Great !!! Thanks !

JulieD said:
Hi Annem

One option
=IF(COUNTIF(A3:CC3,">40"),"yes","no")

--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating hours between 35 and 40 2
Combining If, Vlookup in formula 2
sum of range containing formula in blanks 1
Get a row number of range where a value is between minimum and max 2
Formatting a weekly time sheet 2
Formulas--NEED HELP! 4
Percentage over a date range 3
Trying to calculate hours worked on timecard using "IF" command 6

Back
Top