View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Averi Averi is offline
external usenet poster
 
Posts: 1
Default 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.