IF function

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

Guest

I have just begun a computer course and really feel dumb. I need a formula which will subtract a credit
balance from the limit and give the result if the balance>limit. I have tried all sorts of combinations with
the - sign but to no avail.I begin: =IF(Balance>Limit," ?","") The "" ,Value_If_true, works and always gives
the correct result, a blank. However, the formula I use for Value_If_False always prints the words I use
rather than the result of the subtraction. Help.
 
Jo

With Limit in G3 and Balance in H3 enter this in I3

=IF(H3>G3,G3-H3,"")

Will return negative number if over limit and blank if at or under limit.

Another way of looking at it.

=IF(H3>G3,"Overdrawn","Got some left")

Gord Dibben Excel MVP
 
Hi Jo!

IF(Balance>Limit,Limit-Balance,"")

But I suspect that your problem is one of confusion over the signs of
the various items.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Jo Kinzie said:
I have just begun a computer course and really feel dumb. I need a
Click to expand...
formula which will subtract a credit
balance from the limit and give the result if the balance>limit. I
Click to expand...
have tried all sorts of combinations with
the - sign but to no avail.I begin: =IF(Balance>Limit," ?","") The
Click to expand...
"" ,Value_If_true, works and always gives
the correct result, a blank. However, the formula I use for
Click to expand...
Value_If_False always prints the words I use
 
Is your Value_If_False formula in quotations? If so, remove the quotes. This would make Excel think it is a text statement.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Jo Kinzie wrote: -----

I have just begun a computer course and really feel dumb. I need a formula which will subtract a credit
balance from the limit and give the result if the balance>limit. I have tried all sorts of combinations with
the - sign but to no avail.I begin: =IF(Balance>Limit," ?","") The "" ,Value_If_true, works and always gives
the correct result, a blank. However, the formula I use for Value_If_False always prints the words I use
rather than the result of the subtraction. Help.
 
Back
Top