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
|