View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dtruelove dtruelove is offline
external usenet poster
 
Posts: 3
Default IF greater than Zero

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.

"Roger Govier" wrote:

Hi

=IF (I40-I410,your_figure,"")

--
Regards

Roger Govier


"dtruelove" wrote in message
...
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?