Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2011, 01:00 PM
podko podko is offline =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 Windows XP =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 Office 2007
Novice
=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
 
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
  #2  
Old 12-20-2011, 01:05 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline =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 Windows XP =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 Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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

Quote:
Originally Posted by Pecoflyer View Post
Hi

is this an XL problem?
Could you please provide some more explanation, perhaps post a sample sheet?
It looks almost like calendar in outlook



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
Reply With Quote
  #4  
Old 12-21-2011, 07:37 AM
Catalin.B Catalin.B is offline =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 Windows Vista =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 Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Quote:
Originally Posted by podko View Post
=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 B2for 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...
Reply With Quote
  #5  
Old 12-21-2011, 07:39 AM
Catalin.B Catalin.B is offline =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 Windows Vista =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 Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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



Other Forums: Access Forums

All times are GMT -7. The time now is 12:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft