Make sure you're not putting the TRUE formula in quotes (quotes are only
needed for Text):

=IF(TRUE,SUM(E6*$E$40),"")

In article ,
cyberjack wrote:

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