| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching a Range for a number over 40
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:cc340,"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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching a Range for a number over 40
Hi Annem
One option =IF(COUNTIF(A3:CC3,"40"),"yes","no") -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "annem" wrote: 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:cc340,"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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching a Range for a number over 40
Works Great !!! Thanks !
"JulieD" wrote: Hi Annem One option =IF(COUNTIF(A3:CC3,"40"),"yes","no") -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "annem" wrote: 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:cc340,"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set print range for a number of worksheets | Excel Discussion (Misc queries) | |||
| Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
| Check if a number exists in a range? | Excel Discussion (Misc queries) | |||
| count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
| Select same range from large number of workbooks | Excel Worksheet Functions | |||
Linear Mode
