Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2010, 04:10 AM
Scaffold Scaffold is offline Can't get AND function working Windows XP Can't get AND function working Office 2003
Advanced Beginner
Can't get AND function working
 
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
  #2  
Old 07-05-2010, 09:14 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Can't get AND function working Windows XP Can't get AND function working Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Your formula works normally on my computer.
Reply With Quote
  #3  
Old 07-05-2010, 10:21 AM
Scaffold Scaffold is offline Can't get AND function working Windows XP Can't get AND function working Office 2003
Advanced Beginner
Can't get AND function working
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default

But not on mine. That's why I lost for thoughts.
Reply With Quote
  #4  
Old 07-05-2010, 10:00 PM
velohead velohead is offline Can't get AND function working Windows XP Can't get AND function working Office 2003
Novice
 
Join Date: Jul 2010
Location: QLD, AUS
Posts: 6
velohead is on a distinguished road
Default

Can you copy from excel cell, the exact formula, and paste it into this forum.

I'll copy paste into excel to see if it works.
Reply With Quote
  #5  
Old 07-06-2010, 12:53 AM
Scaffold Scaffold is offline Can't get AND function working Windows XP Can't get AND function working Office 2003
Advanced Beginner
Can't get AND function working
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default

I cannot paste a formula from a cell, because it won't allow it into the cell in the first place. I suspect that it is down to my regional settings which use comma rather than dot for the decimal separator. But I don't know if it's true and how to deal with that.
Reply With Quote
  #6  
Old 07-06-2010, 03:38 PM
velohead velohead is offline Can't get AND function working Windows XP Can't get AND function working Office 2003
Novice
 
Join Date: Jul 2010
Location: QLD, AUS
Posts: 6
velohead is on a distinguished road
Post

I see what you mean.
When I copy paste from post #1, the formula works.
If I then change all commas , to fullstops .
then I get the message "The formula you typed contains an error"

Do you have any formula that contain a comma that work ?
Either in that spreadsheet, or another ?
Reply With Quote
  #7  
Old 07-09-2010, 01:41 AM
Scaffold Scaffold is offline Can't get AND function working Windows XP Can't get AND function working Office 2003
Advanced Beginner
Can't get AND function working
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default

I managed to find a way around. It turned out that ";" replaces the "," in my case. The formula writted words if written like that: =IF(AND((E2<D2);(E2>D3));"OK";"FAIL"). That's good.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get AND function working Signature function not working? prroots Outlook 6 08-17-2015 07:18 AM
Can't get AND function working lastincolumn function rdcsfd Excel Programming 7 02-08-2012 07:50 AM
My weekday function aint working FraserKitchell Excel 12 05-25-2010 04:42 PM
Can't get AND function working Is this possible using the Vlookup or any other function? Delson Excel 4 02-08-2010 01:27 PM
Can't get AND function working Need help on what function to use??? Primeraman Excel 1 06-13-2006 10:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft