Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

1
Trying to formulate an "if" then with more math.
Post Flair (click to view more posts with a particular flair)
Post Body

Hi all. Trying to simplify my work. I am reconciling lottery sales. Column A, I have the readings from today's lottery. Column B, I have the readings from yesterday's lottery. So that's a simple 'sum' formula to find out what's sold. No big deal. But here's the kicker. When a new packet of tickets is opened, it goes back to zero. That makes the sum negative. I need a formula that accounts for column a being smaller than column b. A $1 ticket pack contains 300 tickets. So let's say Thursday there were 256 tickets. A new packet was opened. And Friday the ticket number is 34. So 78 tickets were sold. But excel would recognize it as -222. I need a way to tell it to subtract 256 from 300 and then add 34. I've been playing around with 'if' but I can't get it to work. I am a novice in this. Thanks for your help.

Author
Account Strength
50%
Account Age
10 years
Verified Email
No
Verified Flair
No
Total Karma
374
Link Karma
78
Comment Karma
296
Profile updated: 1 day ago
Posts updated: 3 days ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
7 years ago