Hello! In some cells in the True Price Column, I applied a discount by referencing the cell Conv!C2. For example, the argument in D13 is
=MROUND((D8 * 2) * Conv!C2, 5) where
(D8 * 2) is me calculating the rate,
* Conv!C2 is me applying the discount, and
MROUND(,5) is me rounding to the nearest 5. I would like to create argument to calculate the savings. Here's a semi-layman's explanation of what I would like to do:
IF D13's argument references Conv!C2, take the value of D13 before rounding and calculating the discount, in this case $60.00, then subtract the final value of the cell, in this case $55.00. Then return that value as currency. ELSE, leave the cell blank.
E13 should output $5.00.