Thread: IF,And,OR Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lostinformulas
 
Posts: n/a
Default IF,And,OR Help


I need help adding another condition to my formula.I need AE9 to =
"Epress" or ="EXPU". At this time it only returns a response for
="Express"

=IF(AND(J9="yes",AK9="yes",AE9="Express"),1,"")


I also need this formula to total the column. AE9:AE200.


--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=550065