Thread: Adding formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default Adding formulas

Hello from Steved

I would like to please add the 2 below to a cell, What Do I need to do, They
are two Cities that I want to be added together to be put in Cell C5.

=IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FAL SE))

=IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FAL SE))
Thankyou