How can I display my "false" value as an actual value?

C

Courtney

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?
 
N

Niek Otten

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?
 
C

Courtney

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.
 
N

Niek Otten

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?"
 
Top