Thread: Seting the minimum value in a cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Seting the minimum value in a cell
Hi crispy,

Try this in I11

=IF(H11-500<0,0,H11-500)

HTH
Martin


Reply With QuoteReply With Quote