![]() |
|
![]() |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
=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! |
#2
|
||||
|
||||
![]()
Hi
is this an XL problem? Could you please provide some more explanation, perhaps post a sample sheet?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]() Quote:
A B C 1 CET Availability Duration in hrs 2 08:00 Busy 02:00 3 08:30 Busy 4 09:00 Busy 5 09:30 Busy 6 10:00 7 10:30 8 11:00 9 11:30 10 12:00 11 12:30 Busy 01:00 12 13:00 Busy 13 13:30 14 14:00 15 14:30 16 15:00 17 15:30 18 16:00 Busy 00:30 19 16:30 20 17:00 21 17:30 22 18:00 23 18:30 24 19:00 sorry if I can't describe any better.... thx |
#4
|
|||
|
|||
![]() Quote:
![]() =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... |
#5
|
|||
|
|||
![]()
Just keep in mind that you can use up to 7 IF in a single formula...
|
![]() |
|