Thread: Cell placement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dianethetech Dianethetech is offline
external usenet poster
 
Posts: 6
Default 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