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
|