| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter a formula in a cell that changes per another cell's | Excel Worksheet Functions | |||
| Returning a cell's formula in a different cell | Excel Worksheet Functions | |||
| IF Function to test formula in a cell | Excel Worksheet Functions | |||
| Is there a logical test for a cell's format instead of contents | Excel Worksheet Functions | |||
| Test a cell for a formula present | Excel Discussion (Misc queries) | |||
Threaded Mode
