View Single Post
 
Old 12-20-2011, 01:00 PM
podko podko is offline Windows XP Office 2007
Novice
 
Join Date: Dec 2011
Posts: 2
podko is on a distinguished road
Default =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!
Reply With Quote