software

Hi,

I am wanting a formula that checks if a worksheet balances. Not exactly but
within a dollar.

Something like:
=IF(SUM(J5:J35)=J40lt;gt;1,quot;Holy Smokes, Your Right Onquot;, quot;Ooops, better check
formulasquot;)

What do I need to add?Todd

Todd

maybe something like:

=IF(ABS(SUM(J5:J35)-J40)lt;=1,quot;Holy Smokes, Your Right Onquot;, quot;Ooops, better
check formulasquot;)

Regards

Trevorquot;Toddquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I am wanting a formula that checks if a worksheet balances. Not exactly
gt; but
gt; within a dollar.
gt;
gt; Something like:
gt; =IF(SUM(J5:J35)=J40lt;gt;1,quot;Holy Smokes, Your Right Onquot;, quot;Ooops, better check
gt; formulasquot;)
gt;
gt; What do I need to add?
gt;
gt;
gt; Todd
On Wed, 8 Mar 2006 14:30:05 -0800, Todd
gt; wrote:

gt;Hi,
gt;
gt;I am wanting a formula that checks if a worksheet balances. Not exactly but
gt;within a dollar.
gt;
gt;Something like:
gt;=IF(SUM(J5:J35)=J40lt;gt;1,quot;Holy Smokes, Your Right Onquot;, quot;Ooops, better check
gt;formulasquot;)
gt;
gt;What do I need to add?
gt;
gt;
gt;Todd

=IF(ABS(SUM(J5:J35)-J40)lt;=1,quot;Holy Smokes You're Right Onquot;,quot;Ooops
better check quot;)

HTH
Richard Buttrey
__