LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hidden rows columns won't stay hidden christie Excel Worksheet Functions 0 September 30th 08 05:44 PM
Formula or Code to keep Hidden Rows Hidden Carol Excel Worksheet Functions 6 May 1st 07 11:45 PM
Hidden Columns No Longer Hidden after Copying Worksheet? EV Nelson Excel Discussion (Misc queries) 1 December 6th 06 05:10 PM
How do I detect hidden worksheets or hidden data on a worksheet? Alice Excel Discussion (Misc queries) 4 August 24th 06 03:38 AM
I need my Hidden Rows to stay hidden when I print the sheet. Rosaliewoo Excel Discussion (Misc queries) 2 July 20th 06 07:51 PM


All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"