|
|
|
|
#1
07-06-2010, 03:38 PM
|
|||
|
|||
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 ? 
|
|
#2
07-09-2010, 01:41 AM
|
|||
|
|||
|
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.
|
|
|
|
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 |
Windows XP 
Office 2003
Hybrid Mode