ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   0 =1 (https://www.excelbanter.com/excel-discussion-misc-queries/178135-0-%3D1.html)

vic patel[_2_]

0 =1
 
i like to set up format for lottry ticket count.there is one problem -lottry
ticket start from 0.if i want sheet which count by it self i need to set up
value for 0 as 1.if any one know please help me. i am trying since morning.

David Biddulph[_2_]

0 =1
 
It isn't clear what formula you are using, or which way round your error is.
If you have a formula which gives 0 and you want 1, then add the term +1 to
the end of your formula.
If you have a formula which gives 1 and you want 0, then add the term -1 to
the end of your formula.
--
David Biddulph

"vic patel" wrote in message
...
i like to set up format for lottry ticket count.there is one
problem -lottry
ticket start from 0.if i want sheet which count by it self i need to set
up
value for 0 as 1.if any one know please help me. i am trying since
morning.





All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com