IF statement problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings,

I am trying to write an edit check for an accounting worksheet. For example, cash could be negative (a credit) but would normally be positive (a debit). The debits are in one column and the credits in another. Here is the formula I am trying to use

=IF(G3>0,"","CHECK") where G3 is the normal balance column

Unfortunately, even if G3 is blank nothing shows up

Your help would be appreciated.
 
"Unfortunately, even if G3 is blank nothing shows up"
Rodger, with G3 blank I get check, maybe this is what you want?
=IF(G3>=0,"","CHECK")

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
Rodger said:
Greetings,

I am trying to write an edit check for an accounting worksheet. For
Click to expand...
example, cash could be negative (a credit) but would normally be positive (a
debit). The debits are in one column and the credits in another. Here is the
formula I am trying to use:
 
Your formula will return "CHECK" if G3 is blank, since a blank will never be
greater than 0.

You do not say what your objective is, making it hard to help.


Rodger said:
Greetings,

I am trying to write an edit check for an accounting worksheet. For
Click to expand...
example, cash could be negative (a credit) but would normally be positive (a
debit). The debits are in one column and the credits in another. Here is the
formula I am trying to use:
 
Back
Top