Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBW JBW is offline
external usenet poster
 
Posts: 42
Default Look for data entry in cell

I'm using the IF function to check for 'something' in a cell before
calculating a formula. Trouble is I need it to check that there has been an
entry in the cell, not a number. I need it to look in the cell and say
there's been an entry put into it, whether it's zero or greater, but not look
as a number rather as data.


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 751
Default Look for data entry in cell

Please rephrase. What do you mean "an entry, not a number"? What do
you mean "not look as number rather as data?" Do you by any chance
mean that the cell contains a formula rather than a constant value? Do
you mean it should contain text and not a number? Please be specific
about your condition.

HTH
Kostis Vezerides

On Feb 28, 6:27 pm, JBW wrote:
I'm using the IF function to check for 'something' in a cell before
calculating a formula. Trouble is I need it to check that there has been an
entry in the cell, not a number. I need it to look in the cell and say
there's been an entry put into it, whether it's zero or greater, but not look
as a number rather as data.



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
Cell Entry That Locks Selected Cells From Any Data Entry. ron Excel Worksheet Functions 5 February 16th 07 09:52 PM
Data entry - Copy contents of cell typed in one cell to another ce danie Excel Worksheet Functions 2 March 16th 06 06:51 PM
Blocking entry of data in a cell Rob Excel Worksheet Functions 1 February 5th 06 03:37 PM
data in cell not corresponding with entry Graeme New Users to Excel 1 December 21st 05 04:16 PM
Using a ComboBox for Data Entry into a Cell Jon Turner Excel Worksheet Functions 4 May 27th 05 09:53 PM


All times are GMT +1. The time now is 05:29 PM.

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

About Us

"It's about Microsoft Excel"