Cell content = formula or concrete number? 
Author Message
 Cell content = formula or concrete number?

Does Excel offer an information function which takes the value "true" if
a certain cell content equals a concrete number (e.g.:9384398) and the
value "false" if the content of this cell equals a formula
(e.g.:h120+k120) or vice versa? All available information functions do
not help - as far as I see.

Any information on this topic would be of great help!
Thanks a lot!

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT  
 Cell content = formula or concrete number?
Isnumber will check for both a numeric value and a formula which results in
a numeric value.
The following VBA function results in TRUE only for a formula, as you can
easily test.

Function ContainsFormula(a As Range) As Boolean
ContainsFormula = a.HasFormula
End Function

Regards,

Niek Otten



Quote:
> Does Excel offer an information function which takes the value "true" if
> a certain cell content equals a concrete number (e.g.:9384398) and the
> value "false" if the content of this cell equals a formula
> (e.g.:h120+k120) or vice versa? All available information functions do
> not help - as far as I see.

> Any information on this topic would be of great help!
> Thanks a lot!

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. EXCEL97 - Custom formula to check if cell contents is a formula

2. changing a cells contents using a formula in a different cell

3. Function for "content of cell=formula" or "content of cell=hard number"

4. Extracting Number of Cells with Formulae, Blanks, Numbers and Text

5. Formula to delete cell content

6. Appending to cell contents/formula

7. Deleting cell content while keeping formulas ?

8. Excel 2000, replace part of formula with contents of another cell

9. Use a cells contents as part of a filepath in a formula

10. need formula to paste cell content to differant sheet based on date


 
Powered by phpBB® Forum Software © phpBB Group