Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Question
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
formula question | Excel Worksheet Functions | |||
Formula question | Excel Worksheet Functions | |||
IF formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) |