Thread: Can this formula be placed in CELL AT3 and insert the "x" into CELL B29?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Cramblit Joe Cramblit is offline
external usenet poster
  
Posts: 1
Default Can this formula be placed in CELL AT3 and insert the "x" into CELL B29?
=IF(SUM(B$33:B$44)0,"x","")

I need to have the "x" (or nothing) to appear in cell B29 based on th
SUM shown BUT I want to move the actual formula out of B29 so tha
clearing cell B29 will not have an effect on the working of th
formula. Cell B29 would be completely empty.

Sounds rather simple but I can't figure it out. Maybe it sounds simpl
because it's impossible.

Thanks

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote