View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cwilliams cwilliams is offline
external usenet poster
 
Posts: 17
Default Max Value of a cell

I hit another road block with my formula.

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

The max value can only be $1,000. How do I tell it if D15/52*60% is more
then $1,000 only enter $1,000. If the value is less then $1,000 then enter
the number from the formula. If I19 is no then 0 still needs to be used.

Thanks again to everyone!