Thread: How do I test a cell's formula (ex: Is this cell and Avg or a sum?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karie Karie is offline
external usenet poster
  
Posts: 3
Default How do I test a cell's formula (ex: Is this cell and Avg or a sum?
I want to be able to test the formula for a cell to see if it is an Average
or a Sum.

EX: ( if the first 4 characters of the forumula for A:3 = "=AVG", then B:3 =
"Average")

If not, can I designate cells by color. Then test for all cells that are a
certain color...

EX: (if Color of A:3 is red, then B:3 equals "Average")




Reply With QuoteReply With Quote