Thread: excell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
Default excell
=MAX(B1 *0.00125,100)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"yonkersmike" wrote in message
...
i want to come up with a formula where cell b1 *.00125 if its less than
100,
the value must show min 100.00

Reply With QuoteReply With Quote