Thread: [Solved] Can't get AND function working
View Single Post
 
Old 07-05-2010, 04:10 AM
Scaffold Scaffold is offline Windows XP Office 2003
Advanced Beginner
  
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default Can't get AND function working
Greetings!

I have a big problem. I can't get AND function working withing my IF formulae. Even if I use examples from the Excel's own help =IF(AND(1<A3, A3<100), A3, "The value is out of range."), it keep saying that "The formula you entered contains an error".

My regional settings are set to use comma rather than dot as a decimal separator - can that be the source of the problem? Any other ideas?

Please help!
Reply With Quote