View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stumped stumped is offline
external usenet poster
 
Posts: 37
Default Several Table, need the total discount

I have several tables RED, BLUE, YELLOW and TOTAL DISCOUNT
I need to calculate the greatest amount of the three and give a total
discount.
EX. 2ND DAY=$5, 3RD DAY=$7, TODAY'S PRICE=$8
TOTAL DISCOUNT WOULD EQUAL 2ND DAY (SINCE ITS THE LOWEST) TO TODAY'S PRICE =
$5-$8=TOTAL DISCOUNT=$3
and in the same respect, I need to show that if TODAY'S PRICE is the lowest
to equal TOTAL DISCOUNT=ZERO