View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] tsides@intelligentsystemsconsulting.com is offline
external usenet poster
 
Posts: 9
Default if statement on a pivot table

if column B includes the text "total" exactly, then the following
formula would work (copied to all rows):
=IF(B1="total",F1-E1,"")

however, if by "contains" you mean that the cell in B3 might have the
word "SubTotal" or "Sub Total" or even "Total widgets", then you will
need:
=IF(ISERROR(FIND("total",LOWER(B1))),"",F1-E1)