Currently I am using below nested if statements to get the results. I want to convert into Macro for future use. And I want results to display on last empty column and until last empty cell. Please help me to sort this out
=IF(L2="BI",IF(M2="AL","Onsite allocated to auction",IF(M2="RL","Onsite released for auction",IF(M2="NR","Onsite NOT released for auction",IF(M2="UN","Onsite unsold",0)))))
=IF(OR(L2="ex",L2="sy"),IF(M2="SO",IF((I2>"10/08/2011"+0)*(I2<TODAY()),"Recently Sold",0)))
Jas
Bookmarks