Thread: Max Value of a cell
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Max Value of a cell
Try this........

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


Gord Dibben MS Excel MVP

On Tue, 29 Aug 2006 09:35:02 -0700, cwilliams
wrote:

I tried

=IF(I19="yes",0)*AND(I20<1000,(D15/52)*0.6,"1000")

And this did not work either

Reply With QuoteReply With Quote