ExcelBanter - If function display

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If function display (https://www.excelbanter.com/excel-worksheet-functions/9537-if-function-display.html)

cyberjack

If function display

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

JE McGimpsey

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

All times are GMT +1. The time now is 06:27 PM.