Format for a cell with a formula in it but I don't want the 0 to c
I am trying to format at worksheet and use formula's to reference a different
page. What format can I use so that when there is no information entered in the referenced cell it doesn't show a 0? |
Format for a cell with a formula in it but I don't want the 0 to c
Hi,
Something like this =IF(Sheet2!A1="","",Sheet2!A1) Mike "texansgal" wrote: I am trying to format at worksheet and use formula's to reference a different page. What format can I use so that when there is no information entered in the referenced cell it doesn't show a 0? |
Format for a cell with a formula in it but I don't want the 0 to c
Use something like
#;(#);;@ The trick is to have nothing between the second and third ";" # is for positive numbers (#) is for negative numbers @ is for text "texansgal" wrote: I am trying to format at worksheet and use formula's to reference a different page. What format can I use so that when there is no information entered in the referenced cell it doesn't show a 0? |
Format for a cell with a formula in it but I don't want the 0 to c
Also, how can I write a formula for the following:
I have a total of 4 worksheets. The 1st page is what the 2,3 and 4 references. Example: There are 10 line items on the 1st page. 4 Lines will go on the 2nd page, 4 will go on the 3rd page and 2 will go on the 4th page. How can I make it where IF there are 4 pages, the totals on the 2nd and 3rd pages do not total (the weight) but the whole total of all pages totals on the 4th page? Same for if there are a total of 4 pages, it will give me the # of # pages? Example: There are the 4 pages in the workbook but only 3 will be used. How can I have it format Page 1 of 3, 2 of 3, 3 of 3? "texansgal" wrote: I am trying to format at worksheet and use formula's to reference a different page. What format can I use so that when there is no information entered in the referenced cell it doesn't show a 0? |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com