Thread: Max Value of a cell
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nobody Nobody is offline
external usenet poster
  
Posts: 47
Default Max Value of a cell
Change MAX to MIN

Hope I help you

"cwilliams" wrote:

I entered that formula and it is not calculating if the value is under 1000
only if it is over 1000. Maybe the 1000 is in the wrong place?

=IF(I19="yes",MAX(1000,D15/52*0.6),0)


Reply With QuoteReply With Quote