Thread: If statements
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default If statements
Just amend your formula as follows:

IF (B3 = 10, 0, B3)

Hope this helps.

Pete

Reply With QuoteReply With Quote