Calculating difference between two cells eg: ticket numbers

[MADIME39]

Hello, I have a spreadsheet where I need to enter a beginning ticket stub number in B7, the ending ticket stub number in D7, and then multiply the number sold by the per-ticket cost. When I enter, for example, starting ticket #0 and ending ticket #9, it gives me 9 as a result, however 10 tickets were actually sold (ticket #0, 1, 2, etc). Below, rows 7 and 8, 10 tickets were actually sold, but it's calculating as 9.

I'm an Excel novice, so I thought I could enter "A3-A1+1" in F7, but then if the beginning and ending ticket numbers are blank, it still shows a "1" for tickets sold, and multiplies that "1" by the dollar amount. Since I'm also adding up the total dollar amounts, I can't have that either. I'm sorry if this is confusing!

Thank you in advance for any help you can offer!

 

[Trevor_S]

Try this as your formula - it will only add the 1 if the cells aren't both blank:
=A3-A1+if(A1&A3="",0,1)

 

[Fluff]

How about
=IF(OR(B7="",D7=""),0,D7-B7+1)

 

[MADIME39]

Thank you so much! I was able to complete my document with your help. Have a great day!

 

[Fluff]

Glad we could help & thanks for the feedback