IF greater than Zero
 

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?

IF greater than Zero
 

=if(I40I41,"figure","")

"dtruelove" wrote:

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?

IF greater than Zero
 

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?

IF greater than Zero
 

hi,

=if(I40-I410,[do this],"")


Hope this works fine for you

Thanks,

Shail



dtruelove wrote:
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?

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?

IF greater than Zero
 

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)

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

IF greater than Zero
 

Okay, thanks...For some reason, I'm not getting it. I think I'll leave it
open for a manual entry. Thanks so much!!

"Bob Phillips" wrote:

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)

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