Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if function display | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
in excel how to display results of a function and text in the sam. | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |