Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want a value hidden if it is 0
I am making a invoice out of a spreadhseet using functions and the such.
I want to make the invoice kind of a "template" i guess you could say with all the functions in there, just need to enter the values. And lets say I don't have any items on lines 2-8, so I want the total amount to be 0, or hidden. Example: In Cell I-15, the function is "=F15*G15". In F-15 the value is 2, G-15 the value is 65, because I did 2 hours at $65 per hour. In I-15 it comes up and says $130.00. That's great. But what I wanted to know is if say I want to enter the rest of the formulas down the invoice (I have 10 lines preset). But IF I dont put anything in rows 16-25, then instead of $0.00 showing up in Cells I-16 - I-25, it won't show anything. Is this possible? I can provide the spreadhseet if you need better clarification. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want a value hidden if it is 0
If you want to be blank if it's zero, you can do it by conditional
formatting, or by custom formatting, or by a formula like =IF(F15*G15=0,"",F15*G15) This would, however, leave it blank if the value was genuinely zero, and you may prefer to provide the blank result only when one or more of the inputs is blank, so =IF(COUNT(F15,G15)=2,F15*G15,"") -- David Biddulph "Jimboscomp" wrote in message ... I am making a invoice out of a spreadhseet using functions and the such. I want to make the invoice kind of a "template" i guess you could say with all the functions in there, just need to enter the values. And lets say I don't have any items on lines 2-8, so I want the total amount to be 0, or hidden. Example: In Cell I-15, the function is "=F15*G15". In F-15 the value is 2, G-15 the value is 65, because I did 2 hours at $65 per hour. In I-15 it comes up and says $130.00. That's great. But what I wanted to know is if say I want to enter the rest of the formulas down the invoice (I have 10 lines preset). But IF I dont put anything in rows 16-25, then instead of $0.00 showing up in Cells I-16 - I-25, it won't show anything. Is this possible? I can provide the spreadhseet if you need better clarification. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want a value hidden if it is 0
=IF(F15*G15=0,"",F15*G15) it will show the result only if it is non-zero... or you can have custom format as 0.00;(0.00); This will show positive nos with two decimals, negative in () and supress 0. "Jimboscomp" wrote: I am making a invoice out of a spreadhseet using functions and the such. I want to make the invoice kind of a "template" i guess you could say with all the functions in there, just need to enter the values. And lets say I don't have any items on lines 2-8, so I want the total amount to be 0, or hidden. Example: In Cell I-15, the function is "=F15*G15". In F-15 the value is 2, G-15 the value is 65, because I did 2 hours at $65 per hour. In I-15 it comes up and says $130.00. That's great. But what I wanted to know is if say I want to enter the rest of the formulas down the invoice (I have 10 lines preset). But IF I dont put anything in rows 16-25, then instead of $0.00 showing up in Cells I-16 - I-25, it won't show anything. Is this possible? I can provide the spreadhseet if you need better clarification. Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want a value hidden if it is 0
Thank you both of you! That was a very big help and did exactly what I wanted
it to do. I'm a bit old school when it comes to managing finances on the computer, I tried Quicken and Quickbooks and don't like them, so good old Excel will do me just fine. Thanks! "David Biddulph" wrote: If you want to be blank if it's zero, you can do it by conditional formatting, or by custom formatting, or by a formula like =IF(F15*G15=0,"",F15*G15) This would, however, leave it blank if the value was genuinely zero, and you may prefer to provide the blank result only when one or more of the inputs is blank, so =IF(COUNT(F15,G15)=2,F15*G15,"") -- David Biddulph "Jimboscomp" wrote in message ... I am making a invoice out of a spreadhseet using functions and the such. I want to make the invoice kind of a "template" i guess you could say with all the functions in there, just need to enter the values. And lets say I don't have any items on lines 2-8, so I want the total amount to be 0, or hidden. Example: In Cell I-15, the function is "=F15*G15". In F-15 the value is 2, G-15 the value is 65, because I did 2 hours at $65 per hour. In I-15 it comes up and says $130.00. That's great. But what I wanted to know is if say I want to enter the rest of the formulas down the invoice (I have 10 lines preset). But IF I dont put anything in rows 16-25, then instead of $0.00 showing up in Cells I-16 - I-25, it won't show anything. Is this possible? I can provide the spreadhseet if you need better clarification. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) |