Gah Brain Fart

gwkenny

Well-known Member
Joined
Aug 13, 2002
Messages
565
Having a brain fart.

Need to test if a cell is a formula or directly entered value.

Thanks,

g-
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

gwkenny

Well-known Member
Joined
Aug 13, 2002
Messages
565
Thanks.

Wanted to do it straight on a spreadsheet though with existing functions.

Ideally this is to be used as a logical test for some conditional formatting in another part of the sheet. It's a cosmetic detail. Not worth me programming the test into a custom function (although the time I spent thinking about this simple thing I coulda done that a few times over, lol).

Thanks for responding though!

g-
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
On 2002-10-31 03:00, gwkenny wrote:
Thanks.

Wanted to do it straight on a spreadsheet though with existing functions.

Ideally this is to be used as a logical test for some conditional formatting in another part of the sheet. It's a cosmetic detail. Not worth me programming the test into a custom function (although the time I spent thinking about this simple thing I coulda done that a few times over, lol).

Thanks for responding though!

g-

There is no native worksheet function that does what you want.
 

gwkenny

Well-known Member
Joined
Aug 13, 2002
Messages
565

ADVERTISEMENT

Wahhhhhhhh, lol.

Well, I'm a geek. Guess I'll open up my VB Editor

Thanks!

g-
(still jealous about your solution with regards to matrix math where you multiply two arrays but one of the arrays had to be in reverse order!!!)
 

Ivan F Moala

MrExcel MVP
Joined
Feb 10, 2002
Messages
4,209
On 2002-10-31 03:03, Aladin Akyurek wrote:
On 2002-10-31 03:00, gwkenny wrote:
Thanks.

Wanted to do it straight on a spreadsheet though with existing functions.

Ideally this is to be used as a logical test for some conditional formatting in another part of the sheet. It's a cosmetic detail. Not worth me programming the test into a custom function (although the time I spent thinking about this simple thing I coulda done that a few times over, lol).

Thanks for responding though!

g-

There is no native worksheet function that does what you want.

Actually there is a way to do this Using Xl4

Just Define a name as
IsFormula

In the refers to type in
=GET.CELL(48,Sheet1!$A$1)
Where $A$1 is the cell range to reference

Then just Type in a cell
=IsFormula

Result will be True of False
 

Forum statistics

Threads
1,144,124
Messages
5,722,626
Members
422,448
Latest member
AugyIA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top