Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
beforeclose placement | Excel Discussion (Misc queries) | |||
IF STATEMENT - PLACEMENT OF VALUE IN THE CORRECT CELL | New Users to Excel | |||
Name Placement | Excel Discussion (Misc queries) | |||
Tab placement | Excel Discussion (Misc queries) | |||
Controlling Cell/Cursor Placement | Excel Discussion (Misc queries) |