Don't Really Know

[johnny peso]

In my workbook, if cell A1 is >0, then a macro runs. I want cell A1 to be >0 when ANY entry in the entire Column B is <5. I named col B as a range (Diff). When I enter the formula in cell A1 as thus....

=if("Diff"<5,1,"")

I get error message. Using Excel XP (or rather, trying to learn to..)

 

[barry houdini]

Try this

=IF(COUNTIF(diff,"<5"),1,"")

 

[johnny peso]

Thanks for your help

John