IF greater than Zero

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

Guest

Hope this isn't a duplicate, but my previous post never appeared: I have a
running spreadsheet. I only want a figure to show in I42 if I40-I41 is
greater than zero. What is the correct formula?
 
Thanks to all for responding so quickly! I know this has got to be simple as
dirt, but I have hit a blank and I'm just not getting it. This spreadsheet
is actually an expense report. Cell I40 would be the amount of a net check.
I41 would contain any amounts noted for miscellaneous deductions. I42 would
be the amount of an adjusted check, but ONLY if there was a figure in I42 to
be deducted from I41 which equaled an amount greater than zero. Otherwise,
I42 would remain blank.
 
You cannot have a formula in I42 and an value, you will need to use another
cell.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Okay, thanks...For some reason, I'm not getting it. I think I'll leave it
open for a manual entry. Thanks so much!!
 
Back
Top