Thread: If cell equals, give total of another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default If cell equals, give total of another cell
=IF(Historical!I10="X",Historical!A10,"")


Vaya con Dios,
Chuck, CABGx3


"Lori Burton" wrote:

I have a formula that looks likes this:

=IF(Historical!I10="X","Historical!A10","")

If true, it returns "Historical!A10"

How do I write this formula to give me the value of A10 and not the name of
the cell?
--
Lori
Reply With QuoteReply With Quote