Can't get AND function working

		Microsoft Office Forums > Microsoft Excel > Excel
Can't get AND function working

FAQ

Thread Tools

Display Modes

07-09-2010, 01:41 AM

Scaffold

Windows XP Can't get AND function working

Office 2003

Advanced Beginner

Join Date: Oct 2009

Location: Moscow, Russia

Posts: 36

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Signature function not working?	prroots	Outlook	6	08-17-2015 07:18 AM
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
Is this possible using the Vlookup or any other function?	Delson	Excel	4	02-08-2010 01:27 PM
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 10:58 PM.