johnny peso
New Member
- Joined
- Nov 24, 2005
- Messages
- 8
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..)
=if("Diff"<5,1,"")
I get error message. Using Excel XP (or rather,