How To Make Numbers In Cell Not Exceed 99?

[beau21]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hey guys.

In excel, when I enter some formulas, I'm getting some numbers higher than 99. I'm getting some 100-115 numbers but for what I'm doing I don't want anything higher than 99. Is there a way to format the cell to not exceed the number 99 in any given cell? or maybe something to add to the end of the formula?

I hope this makes sense.

Thanks

 

[Laroche J]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hey guys.

In excel, when I enter some formulas, I'm getting some numbers higher than 99.
I'm getting some 100-115 numbers but for what I'm doing I don't want anything
higher than 99. Is there a way to format the cell to not exceed the number 99
in any given cell? or maybe something to add to the end of the formula?

I hope this makes sense.

Thanks

Try
=MIN(99,your_formula)
where your_formula is the one currently in the cell.

JL
Mac OS X 10.4.11, Office v.X 10.1.9

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hey guys.

In excel, when I enter some formulas, I'm getting some numbers higher than
99. I'm getting some 100-115 numbers but for what I'm doing I don't want
anything higher than 99. Is there a way to format the cell to not exceed the
number 99 in any given cell? or maybe something to add to the end of the
formula?

One way:

=MIN(99, <your existing formula>)