Cell placement
 

I am trying to take data from 3 different columns and put it in either of two
other columns. For example:

F47 is a date formatted MM/DD/YY and T47 is a number from 1 thru a gizillion,

IF(AND(DAY(F47)27,T47<2),T47,T47/M47)

I am trying to say if the date is more than say 4/28/06 and the T47 is
greater than 30 put the answer in column xx, if not, put it in this column

Thanks

--
DMM

Cell placement
 

A formula can only return a result in the cell that holds the formula, so
you must use 2 formulas in 2 columns


--
Regards,

Peo Sjoblom


"Dianethetech" wrote in message
...
I am trying to take data from 3 different columns and put it in either of
two
other columns. For example:

F47 is a date formatted MM/DD/YY and T47 is a number from 1 thru a
gizillion,

IF(AND(DAY(F47)27,T47<2),T47,T47/M47)

I am trying to say if the date is more than say 4/28/06 and the T47 is
greater than 30 put the answer in column xx, if not, put it in this column

Thanks

--
DMM

Cell placement
 

Can you explain further?
--
DMM


"Peo Sjoblom" wrote:

A formula can only return a result in the cell that holds the formula, so
you must use 2 formulas in 2 columns


--
Regards,

Peo Sjoblom


"Dianethetech" wrote in message
...
I am trying to take data from 3 different columns and put it in either of
two
other columns. For example:

F47 is a date formatted MM/DD/YY and T47 is a number from 1 thru a
gizillion,

IF(AND(DAY(F47)27,T47<2),T47,T47/M47)

I am trying to say if the date is more than say 4/28/06 and the T47 is
greater than 30 put the answer in column xx, if not, put it in this column

Thanks

--
DMM

Cell placement
 

You would need 2 formulas (or VBA code) if you want values to change in 2
places, you posted (I changed the second criteria to 30 from 2 since you
wrote greater than 30)

=IF(AND(DAY(F47)27,T4730),T47,"")

"in xx column"

then in "this column"

=IF(AND(DAY(F47)27,T4730),"",T47/M47)

however if the date is 03/29/06 it will still trigger one of the conditions
so maybe you should use

=IF(AND(F47DATE(2006,4/27),T4730),T47,"")



--
Regards,

Peo Sjoblom






"soconfused" wrote in message
...
Can you explain further?
--
DMM


"Peo Sjoblom" wrote:

A formula can only return a result in the cell that holds the formula, so
you must use 2 formulas in 2 columns


--
Regards,

Peo Sjoblom


"Dianethetech" wrote in message
...
I am trying to take data from 3 different columns and put it in either
of
two
other columns. For example:

F47 is a date formatted MM/DD/YY and T47 is a number from 1 thru a
gizillion,

IF(AND(DAY(F47)27,T47<2),T47,T47/M47)

I am trying to say if the date is more than say 4/28/06 and the T47 is
greater than 30 put the answer in column xx, if not, put it in this
column

Thanks

--
DMM

Cell placement
 

Thanks
--
DMM


"Peo Sjoblom" wrote:

You would need 2 formulas (or VBA code) if you want values to change in 2
places, you posted (I changed the second criteria to 30 from 2 since you
wrote greater than 30)

=IF(AND(DAY(F47)27,T4730),T47,"")

"in xx column"

then in "this column"

=IF(AND(DAY(F47)27,T4730),"",T47/M47)

however if the date is 03/29/06 it will still trigger one of the conditions
so maybe you should use

=IF(AND(F47DATE(2006,4/27),T4730),T47,"")



--
Regards,

Peo Sjoblom






"soconfused" wrote in message
...
Can you explain further?
--
DMM


"Peo Sjoblom" wrote:

A formula can only return a result in the cell that holds the formula, so
you must use 2 formulas in 2 columns


--
Regards,

Peo Sjoblom


"Dianethetech" wrote in message
...
I am trying to take data from 3 different columns and put it in either
of
two
other columns. For example:

F47 is a date formatted MM/DD/YY and T47 is a number from 1 thru a
gizillion,

IF(AND(DAY(F47)27,T47<2),T47,T47/M47)

I am trying to say if the date is more than say 4/28/06 and the T47 is
greater than 30 put the answer in column xx, if not, put it in this
column

Thanks

--
DMM