"real" formula

[Jiri Cihar]

I have a large spreadsheet model to audit. There is a lot of
"semiformulas" meaning formula like =4569 + (7891*0,15) and so on. I
need to find a macro picking up these type of formula. I am not
interested in "real" formulas created by user by means of
FurmulaWizzard ( formulas concerning function names like SUM, VLOOKUP
etc.)

Thank you for your assistance.

Jiri Cihar

 

[Guest]

hi,
you the keyboard shortcut ctrl+ ~
this will show formulas as formulas instead of
calculations.
press ctrl+~ again returns the view back to calculations.
if =4569 + (7891*0.15) is calculating a value then it is a
real formula.