View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Teri Teri is offline
external usenet poster
 
Posts: 77
Default 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!