| 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 | |||
Hybrid Mode
