Thread: IF Statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nt nt is offline
external usenet poster
 
Posts: 10
Default IF Statement

=IF(A3:A200=(TRIM("Total Revenue:")),B3:B200,0)

If the text Total Revenue appears in A19, I would like Excel to return the
corresponding data in B19. If not, then return 0.

What am I doing wrong? I have looked throughout this site and am not
finding my answer so if it has been answered before, please point me to the
correct place. My apologies/thanks in advance