Maximum Value in a Cell
 

I need to multiply cell G2 by $25. The maximum value should be $250. Can
anyone help me write this? I've checked some of the other formulas, and
can't seem to make it work for my situation.

Thank you!

Maximum Value in a Cell
 

Try

=MIN(G2*25,250)


Regards,

Peo Sjoblom


"Teri" wrote in message
...
I need to multiply cell G2 by $25. The maximum value should be $250. Can
anyone help me write this? I've checked some of the other formulas, and
can't seem to make it work for my situation.

Thank you!

Maximum Value in a Cell
 

=MIN(250,G2*25)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Teri" wrote in message
...
I need to multiply cell G2 by $25. The maximum value should be $250. Can
anyone help me write this? I've checked some of the other formulas, and
can't seem to make it work for my situation.

Thank you!

Maximum Value in a Cell
 

That was so simple!!! Thank you both of you! I don't know why I couldn't
make it work..

"Bernard Liengme" wrote:

=MIN(250,G2*25)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Teri" wrote in message
...
I need to multiply cell G2 by $25. The maximum value should be $250. Can
anyone help me write this? I've checked some of the other formulas, and
can't seem to make it work for my situation.

Thank you!