Using fields to test on empty ?

NobodysPerfect · #1 10-08-2014, 06:01 AM

Hi to all

I'm looking for a non VBA solution (macros not allowed) for the following problem:

Given: table with 3 columns. In columns A and B values can be entered but need not. Possible values in A and B: positive, negative, decimals and zero). The result of the calculation in column C is =(b1-a1) \# "+0,00;-0,00;0,00.

Challenge: The result must not be displayed if one (or both) of the cells A1 or B1 is empty. So I tried:

{ IF { = AND ( { = ABS(b1) } > 0 , { = ABS(a1) } > 0) } = 1 "{ =(b1-a1) \# "+0,00;-0,00;0,00 }" }

Works fine unless A1 and B1 are zero ("0") because then AND will be false. So I tried some calculation and set the condition to ">= 0" expecting empty fields would throw some error:

{ IF { = AND ( { = ABS(b1*1) } >= 0 , { = ABS(a1*1) } >= 0) } = 1 "{ =(b1-a1) \# "+0,00;-0,00;0,00 }" }

Unfortunately, Word does calculate with empty fields, it simply assumes "0". So there are equal results with empty cells and cells containing "0".

Do you see any chance to test cells on empty (or not numeric) just using fields? I don't.

Thanks for any help
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