Hamster & Pene

Posts: n/a

if formula in cell

Hi Team

What I want to do is, if
Cell.... A1 contains formula then do something if it contain a number do
something else.

I thought it would be =if(ISREF(A1),100,200) or the ISNUM function, the IS
function don't detect

thanks Phill

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Using contents of a cell in a formula	Mike	Excel Discussion (Misc queries)	4	June 9th 05 03:10 AM
Formula that referance a Cell	MESTRELLA29	Excel Discussion (Misc queries)	1	February 10th 05 11:18 PM
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

All times are GMT +1. The time now is 06:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us