Thread: Maximum and minimum cell value
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Maximum and minimum cell value
whoops: that should have a = in front of it
=MIN(MAX(Z99,.05*C21),Z28)

Reply With QuoteReply With Quote