Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 10-11-2014, 02:19 AM
NobodysPerfect NobodysPerfect is offline Using fields to test on empty ? Windows 8 Using fields to test on empty ? Office 2010 32bit
Competent Performer
Using fields to test on empty ?
 
Join Date: Jan 2014
Location: Germany
Posts: 136
NobodysPerfect is on a distinguished road
Default

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
test Cheekychino PowerPoint 1 04-08-2013 09:09 PM
Using fields to test on empty ? 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
Using fields to test on empty ? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:37 PM.


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