View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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!