View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LisaLisa
 
Posts: n/a
Default Excel formula: how to write $32 AND 65% = "Corporate Gold"

I need help on how to write a formula to compare two columns of results and
return a text field answer.
Column A $32
Column B 65%
Any company listed that is $32 AND 65% will return "Corporate Gold" in
Column C. Thanks!