Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I display my "false" value as an actual value?
I have a formula that I need to display my "false" value as the actual value
of the cell. I have looked and looked, tried many different formulas but cannot do this. Can someone help me out? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I display my "false" value as an actual value?
Can you explain? What is "false value" or "actual value"?
Is there a formula in the cell? What is that formula? What are the input values? What result do you get? What did you expect instead? -- Kind regards, Niek Otten "Courtney" wrote in message ... I have a formula that I need to display my "false" value as the actual value of the cell. I have looked and looked, tried many different formulas but cannot do this. Can someone help me out? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I display my "false" value as an actual value?
I have a mathmatical summary of values that exceed my end value (true) of 5;
i.e. 7 (false) and within my spreadsheet I want not to show the 7 but to show the 5 instead. "Niek Otten" wrote: Can you explain? What is "false value" or "actual value"? Is there a formula in the cell? What is that formula? What are the input values? What result do you get? What did you expect instead? -- Kind regards, Niek Otten "Courtney" wrote in message ... I have a formula that I need to display my "false" value as the actual value of the cell. I have looked and looked, tried many different formulas but cannot do this. Can someone help me out? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I display my "false" value as an actual value?
What about answering questions of people trying to help?
Try something like =Min(YourFormula,5) Do post again but PLEASE not without any details. Your current question is of the type "This thing doesn't do what I want it to do. Any ideas?" -- Kind regards, Niek Otten "Courtney" wrote in message ... I have a mathmatical summary of values that exceed my end value (true) of 5; i.e. 7 (false) and within my spreadsheet I want not to show the 7 but to show the 5 instead. "Niek Otten" wrote: Can you explain? What is "false value" or "actual value"? Is there a formula in the cell? What is that formula? What are the input values? What result do you get? What did you expect instead? -- Kind regards, Niek Otten "Courtney" wrote in message ... I have a formula that I need to display my "false" value as the actual value of the cell. I have looked and looked, tried many different formulas but cannot do this. Can someone help me out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
display actual number or zero, whichever is greater | Excel Discussion (Misc queries) | |||
Actual value a non-zero number but display is Zero | Excel Discussion (Misc queries) | |||
change display font to actual selected font | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) |