=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

Catalin.B · #1 12-21-2011, 07:37 AM

Quote:

Originally Posted by podko

=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!

Your formulas should be in B1 and B2

for IF A1=1 then B1=x and B2=x):
=IF(A1=1,"x",IF(A1=2,"Y",IF(A1=3,"Z","this is what you get if A1 is not 1,2,3"))) .Build other cells formulas the same way...

Catalin.B · #2 12-21-2011, 07:39 AM

Just keep in mind that you can use up to 7 IF in a single formula...