Looking for a formula...
 

I am trying to create a sheet that will run off of a clock I have in excel
via Reuters. Basically what i want to find out if there is an "If x = this,
then cell = that". Does anyone know of an "If,Then" function??

Looking for a formula...
 

that would be:
=if(cell to evaluate,action to perform if true,action to perform if false)

if you want to extract a part of the time there's
=month(cell to evaluate) - Gives you the month number
=Day(cell to evaluate) - Gives you the day in that month
=year(cell to evaluate) - Gives you the year
and more available as well...

"Justin" wrote:

I am trying to create a sheet that will run off of a clock I have in excel
via Reuters. Basically what i want to find out if there is an "If x = this,
then cell = that". Does anyone know of an "If,Then" function??

Looking for a formula...
 

Justin,

See the IF function in Help. E.g.,


=IF(A110,"Greater Than 10","Not Greater Than 10")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Justin" wrote in message
...
I am trying to create a sheet that will run off of a clock I have in excel
via Reuters. Basically what i want to find out if there is an "If x =
this,
then cell = that". Does anyone know of an "If,Then" function??

Looking for a formula...
 

On Thu, 4 Jan 2007 06:32:01 -0800, Justin
wrote:

I am trying to create a sheet that will run off of a clock I have in excel
via Reuters. Basically what i want to find out if there is an "If x = this,
then cell = that". Does anyone know of an "If,Then" function??

A FUNCTION can only return a value; it cannot change another cell.

So you either put the formula into "cell"

cell: =IF(x=this,that,"")

or you write a VBA SUB to check x and then change CELL

--ron