View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
leonardoromero leonardoromero is offline
external usenet poster
 
Posts: 4
Default Organization of Aging Report

Good Afternoon,

I currently have an aging report with the below data:

1-30 Days 31-60 Days 61 - 90 Days Sum
a. -2491.02 100 368.98 -2022.04
b. -5,000 29443.04 -5,000 19,443.04
c. 10.18 5.00 28.95 44.13
d.

What I require is that for the greatest absolute value to be populated in
the below table which will show which period the overall sum of aging
pertains to. I have used IF statements however I was unable to get this to
work due to the negative amounts.

1-30 Days 31-60 Days 61 - 90 Days
a. -2022.04
b. 19,443.04
c. 44.13

Please let me know if you have a solution for this.
:)

Leo