When I use a formula as the "true" in excel, the formula is displayed as the
answer rather than the result of the formula. How can I amend this? The true
answer is "sum(e6*$e$40). I am trying to calculate the discount given if an
order is over a certain sum