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!