Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF function
I am trying to use the IF function to look at a range of cells and return a
true false value if any cell in that range is above certain number. i.e. =IF(B7:E750000,100,0) however, it is returning a false value if any of the cells in the range are false not a true value if any are true, what am I missing? Thanks in advance for any help. |
#2
|
|||
|
|||
Use countif
=IF(COUNTIF(B7:E7,"50000"),100,0) Regards, Peo Sjoblom "ROBERT P. SANDOZ" wrote: I am trying to use the IF function to look at a range of cells and return a true false value if any cell in that range is above certain number. i.e. =IF(B7:E750000,100,0) however, it is returning a false value if any of the cells in the range are false not a true value if any are true, what am I missing? Thanks in advance for any help. |
#3
|
|||
|
|||
Hi Robert
If you want true to be returned when any of the four numbers are over 50000 and false to be returned if all of the numbers are 50000 or less try this formula =IF(COUNTIF(B7:E7,""&50000)=1,100,0) Cheers JulieD "ROBERT P. SANDOZ" <ROBERT P. wrote in message ... I am trying to use the IF function to look at a range of cells and return a true false value if any cell in that range is above certain number. i.e. =IF(B7:E750000,100,0) however, it is returning a false value if any of the cells in the range are false not a true value if any are true, what am I missing? Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |