Formula Question
 

I have a formula (geared towards adding up my project hours) that
reads, =A2-A1*24. This works fine. However, in addition, I need it
to also say if the result is zero then it should have a null value.
Is this possible?

Formula Question
 

One way:

=IF(A2=A1,"",A2-A1*24)

In article .com,
wrote:

I have a formula (geared towards adding up my project hours) that
reads, =A2-A1*24. This works fine. However, in addition, I need it
to also say if the result is zero then it should have a null value.
Is this possible?

Formula Question
 

On Feb 19, 10:06 am, wrote:
I have a formula (geared towards adding up my project hours) that
reads, =A2-A1*24. This works fine. However, in addition, I need it
to also say if the result is zero then it should have a null value.
Is this possible?

=if(A2 - A1*24 = 0, "", A2 - A1*24)

Unfortunately, I don't know any way to avoid computing the formula
twice, unless you are willing to use a helper cell, which you could
hide.

Formula Question
 

On Feb 19, 10:18 am, I wrote:
On Feb 19, 10:06 am, wrote:
I have a formula (geared towards adding up my project hours) that
reads, =A2-A1*24. This works fine. However, in addition, I need it
to also say if the result is zero then it should have a null value.

=if(A2 - A1*24 = 0, "", A2 - A1*24)
Unfortunately, I don't know any way to avoid computing the formula
twice

Well, I am assured that you can leave the formula as you had it and
simply set up a custom formula. But I have not yet figured the
correct syntax :-(.

However, if you null values for zeros for the entire spreadsheet, you
could uncheck Tools - Options - View - Zero Values.

Formula Question
 

On Feb 19, 10:39 am, I wrote:
Well, I am assured that you can leave the formula as you had it and
simply set up a custom formula. But I have not yet figured the
correct syntax :-(.

The Help documentation for custom formats leaves a lot to be desired.
But the following might suffice, if you currently use the General
format:

general;-general;

However, if you null values for zeros for the entire spreadsheet, you
could uncheck Tools - Options - View - Zero Values.

But I usually avoid "format" options that affect the entire
spreadsheet.