ExcelBanter - formula in a cell or not?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula in a cell or not? (https://www.excelbanter.com/excel-worksheet-functions/22347-formula-cell-not.html)

michel beuseling

formula in a cell or not?

Excelfanatics

I'm trying to make interactive exercises for my students.
How can I detect if a value in a cell is the result of a formula in the cell
or not?

Thanks

--
michel beuseling

º¼ÖÝÈË

edit--go to --formula

I'm trying to make interactive exercises for my students.
How can I detect if a value in a cell is the result of a formula in the
cell
or not?

Thanks

--
michel beuseling

Max

If you press F5 Special Check "Formulas" OK
it'll select the cells with formulas in the sheet
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"michel beuseling" wrote in message
...
Excelfanatics

I'm trying to make interactive exercises for my students.
How can I detect if a value in a cell is the result of a formula in the
cell
or not?

Thanks

--
michel beuseling

All times are GMT +1. The time now is 08:11 PM.