software

I have a formula that I need to display my quot;falsequot; 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?

Can you explain? What is quot;false valuequot; or quot;actual valuequot;?
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

quot;Courtneyquot; gt; wrote in message
...
gt;I have a formula that I need to display my quot;falsequot; value as the actual
gt;value
gt; of the cell. I have looked and looked, tried many different formulas but
gt; cannot do this. Can someone help me out?
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.

quot;Niek Ottenquot; wrote:

gt; Can you explain? What is quot;false valuequot; or quot;actual valuequot;?
gt; Is there a formula in the cell? What is that formula? What are the input
gt; values? What result do you get? What did you expect instead?
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Courtneyquot; gt; wrote in message
gt; ...
gt; gt;I have a formula that I need to display my quot;falsequot; value as the actual
gt; gt;value
gt; gt; of the cell. I have looked and looked, tried many different formulas but
gt; gt; cannot do this. Can someone help me out?
gt;
gt;
gt;

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 quot;This thing doesn't do what I want it to do. Any ideas?quot;

--
Kind regards,

Niek Otten

quot;Courtneyquot; gt; wrote in message
...
gt;I have a mathmatical summary of values that exceed my end value (true) of
gt;5;
gt; i.e. 7 (false) and within my spreadsheet I want not to show the 7 but to
gt; show
gt; the 5 instead.
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; Can you explain? What is quot;false valuequot; or quot;actual valuequot;?
gt;gt; Is there a formula in the cell? What is that formula? What are the input
gt;gt; values? What result do you get? What did you expect instead?
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;Courtneyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a formula that I need to display my quot;falsequot; value as the actual
gt;gt; gt;value
gt;gt; gt; of the cell. I have looked and looked, tried many different formulas
gt;gt; gt; but
gt;gt; gt; cannot do this. Can someone help me out?
gt;gt;
gt;gt;
gt;gt;