Previous Topic Next Topic

Someone Please solve this ...

Closed
Baswick - May 1, 2010 at 12:07 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 1, 2010 at 06:41 AM
Issue 1:

I am trying to count daily ticket sold quantity by entering daily starting ticket serial number in A1 and ending ticket number in A2. How can i get the correct count amount in A3.
Eg: Today i started selling ticket serial number 5001 (A1) and i sold up to 5030 (A2). SO if i subtract A2 from A1 answer comes 29, but the correct qty should be 30 (A3). How can i deal with this. Need a kind help from anyone possible.

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 1, 2010 at 06:41 AM
It all depends on how you write data

lets say
A1 =15 is the starting ticket number
A2 =30 is the ending ticket number
so it means I have sold ticket number 15, 16, 17... 29 and have sold 15 tickets
and you can use A2-a1

but if lets say
A1 =15 is the starting ticket number that you sold
A2 =30 is the ending ticket number that you sold
so it means I have sold ticket number 15, 16, 17... 30 and have sold 16 tickets
and you can use A2-a1 +1
0