View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J_Swoll J_Swoll is offline
external usenet poster
 
Posts: 1
Default =IF((F6="C06"&G6="A"),E6,0) both F6 and G6 are true

I am creating a spread sheet and I need to add colums together based on two
different inputs. the "IF statement" seems to to work fine with only one
condition such as:
=if(F6="C06",E6,0) + if(F7="C06",E7,0)
This statement will add E6 to E7 if the F cell is true and it works, How do
I check the condition of two cells.