Overages and Shortages
 

Hi Guys!
I was hoping you could help me
My workbook is set up like this


A. B. C. D. E
Date Cash on Hand System Cash Overage Shortage
Data is on rows 4-34
I need columns D and E to show the overages as a positive number or 0 if there is none
and the shortages to show a negative number or 0 if there is none.

Overages and Shortages
 

Averi wrote:

Hi Guys!
I was hoping you could help me

Why did you initially post this in a 13-year-old thread? Three times, even.

My workbook is set up like this


A. B. C. D. E
Date Cash on Hand System Cash Overage Shortage
Data is on rows 4-34
I need columns D and E to show the overages as a positive number or 0 if
there is none
and the shortages to show a negative number or 0 if there is none.

In D4 enter this formula:

=IF(B4-C40,B4-C4,0)

In E4 enter this formula:

=IF(B4-C4<0,B4-C4,0)

Copy them both down to row 34.


This is pretty basic stuff. If you're not familiar with this kind of thing,
you may want to take some sort of "intro to Excel" class. Or read a book on
the subject. Or at least read an online tutorial. Wikibooks has a decent one:

https://en.wikibooks.org/wiki/Microsoft_Office#Excel

--
You managed to find a way to win...
and everybody still loses!