Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
michel beuseling
 
Posts: n/a
Default 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



  #2   Report Post  
ΊΌΦέΘΛ
 
Posts: n/a
Default

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





  #3   Report Post  
Max
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can a Formula in Cell X modify Cell Y? alMandragor Excel Discussion (Misc queries) 7 February 10th 05 09:51 PM
Cell shows formula and not the result of the formula. stumpy Excel Worksheet Functions 2 January 14th 05 04:44 PM
looking for a formula Amanda Excel Worksheet Functions 5 January 5th 05 07:37 AM
I want the results of a formula to show in cell, NOT THE FORMULA! ocbecky Excel Discussion (Misc queries) 4 December 10th 04 08:39 PM
How do I do math on a cell name in formula? Mark Mulik Excel Worksheet Functions 3 November 23rd 04 03:43 PM


All times are GMT +1. The time now is 09:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"