validation - basic

Posted by wayne beasley on January 29, 2002 7:25 PM

i'm trying to calculate cell G13 by getting f12 + e13 - f13.
I dont want a value to display if f13 has no data.

this is a simple reconciliation spreadsheet.

can someone please give us a solution and ease my frustration

thanks

Posted by anno on January 29, 2002 7:51 PM

wayne
in G13, put =IF(ISBLANK(F13),0,F12+E13-F13) and custom format G13 as 0;-0;.
you could also use =IF(ISBLANK(F13),"",F12+E13-F13) without the custom formatting but as mark w has pointed out previously the "" will cause any arithmetic functions which include G13 to screw up.

Posted by anno on January 29, 2002 8:28 PM

last post didn't show properly - that formula should be...

=IF(ISBLANK(F13),0,F12+E13-F13)
or, in case the plus and minus symbols don't come out again, =if(isblank(f13),0,f12[plus sign]e13[minus sign]f13)
fingers crossed...

Posted by wayne beasley on January 30, 2002 11:01 AM

Thanks, just what i needed

thanks, worked like a charm