Thread: If cell equals, give total of another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lori Burton
 
Posts: n/a
Default If cell equals, give total of another cell
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