=IF A1=1 then B1=x and B2=x also =IF A1=2 then B1=x and B2=x and B3=x and B4=x
=IF A1=1 then B1=x and B2=x also =IF A1=2 then B1=x and B2=x and B3=x and B4=x, where x = anything you want i.e. YES, BUSY etc....
so an example:
if col A1 = 1hrs, colB1 and B2 = busy, but
if col A1 = 2hrs, col B1, B2, B3, B4 = busy, so B1 is a 1/2hrs reference
thanks a lot!
|