![]() |
|
#4
|
|||
|
|||
|
Sorry for re-opening this thread, but ...
... to work with negative values the {REF Text1} = {=Text1} part has to be formatted the same way, the FormField is formatted: e.g. {REF Text1} = {=Text1 \# "0,00"}. Otherwise IF will return FALSE. That's at least what I experienced. Now each value is accepted and calculated the way it should be. Cheers NP |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| test | Cheekychino | PowerPoint | 1 | 04-08-2013 09:09 PM |
Write Test
|
dkub | Word VBA | 1 | 07-21-2012 09:01 PM |
| Apparently empty (blank) cells aren't empty | daymaker | Excel | 3 | 03-08-2012 03:41 PM |
Vba, Is there a better way to test empty cells?
|
Hwyn | Excel Programming | 2 | 11-14-2011 11:44 AM |
| Test after presentation? | barnkat | PowerPoint | 0 | 08-13-2010 10:58 AM |