BIG IF

swaink · Apr 17th, 2002, 10:10 AM

Hi Everyone

I have a formula in one cell that returns TRUE/FALSE.

If the value is TRUE I want to update a cell on another worksheet to read "Booked"

Can anyone Help

Kev

Mark W. · Apr 17th, 2002, 10:19 AM

Quote:

On 2002-04-17 09:10, swaink wrote:
Hi Everyone

I have a formula in one cell that returns TRUE/FALSE.

If the value is TRUE I want to update a cell on another worksheet to read "Booked"

Can anyone Help

Kev
[img]/board/images/smiles/icon_confused.gif[/img]

...and, if it's FALSE?

Mark O'Brien · Apr 17th, 2002, 10:22 AM

For arguments sake, let's say that cell A1 on sheet1 is the that will return the TRUE/FALSE value. Let's say that cell B2 on Sheet2 is the cell that's going to say "Booked" or "Available" (or whatever the FALSE text will be)

Go to Cell B2 on sheet2 and put in this formula:

=IF(Sheet1!A1 = TRUE,"Booked","Available")

HTH

_________________
[b] Mark O'Brien

[ This Message was edited by: Mark O'Brien on 2002-04-17 10:02 ]

Mark W. · Apr 17th, 2002, 10:30 AM

Quote:

=IF(Sheet1!A1 = TRUE,"Booked","Avaliable")

The bolded portion of you IF above is unnecessary. Instead, consider using...

=IF(Sheet1!A1,"Booked","Avaliable")

Mark O'Brien · Apr 17th, 2002, 10:44 AM

Yeah, I know but I'm anal about implicitly stating things like that (in programming or whatever. Comes through messing about with other people's code, I like to make things more readable when I'm a novice.

I'm just chuffed that that's your only comment about the formula.

Mark W. · Apr 17th, 2002, 10:48 AM

Quote:

On 2002-04-17 09:44, Mark O'Brien wrote:
Yeah, I know but I'm anal about implicitly stating things like that (in programming or whatever. Comes through messing about with other people's code, I like to make things more readable when I'm a novice.

I'm just chuffed that that's your only comment about the formula.

Well, I did let the spelling of "available" slip by...

Now, that's anal!!

[ This Message was edited by: Mark W. on 2002-04-17 09:49 ]

Mark O'Brien · Apr 17th, 2002, 11:10 AM

What spelling of "Available"? You're the guy that can't spell that word.

Mantra(don't notice the edit, don't notice the edit....)

You're just po'd 'cos I stepped out of my bounds from VBA to "built in function" crap.

Actually yesterday, and just for you, I populated Sheet1 with the value "1" in every cell. My machine can handle that, but any data that occupies more than 8 bits is going to crap it out for me.

Aladin Akyurek · Apr 17th, 2002, 11:22 AM

Quote:

On 2002-04-17 09:10, swaink wrote:
Hi Everyone

I have a formula in one cell that returns TRUE/FALSE.

If the value is TRUE I want to update a cell on another worksheet to read "Booked"

Can anyone Help

Kev

Kev,

To which formula are you referring and where exactly do you want "Booked" appear when that formula returns/computes TRUE?

Aladin

Mark W. · Apr 17th, 2002, 11:42 AM

Quote:

On 2002-04-17 10:10, Mark O'Brien wrote:
You're just po'd 'cos I stepped out of my bounds from VBA to "built in function" crap.

PO'd? Nah!! We welcome you into the "Built-in" fold.

swaink · Apr 18th, 2002, 03:53 AM

Hi Guys

Just to clarify where Im at.
On sheet 1 I'm using code and a button, the user will click this button to confirm a bookin. If the button is clicked it will update say cell C9 to read TRUE.

Now in another cell (G12) using Aladins formula "Data!"&ADDRESS(MATCH(C12,DATES,0)+2,2)I have obtained the address of a cell on Sheet 2.

If the value in C9 is false I don't want to do anything, but if its TRUE then I want the cell on Sheet2 to read "Booked"

So Im trying to use the address retreived by the code in G12 as a reference point.

Phew I hope that makes sense

Apr 17th, 2002, 10:44 AM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Yeah, I know but I'm anal about implicitly stating things like that (in programming or whatever. Comes through messing about with other people's code, I like to make things more readable when I'm a novice. I'm just chuffed that that's your only comment about the formula. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 17th, 2002, 11:10 AM	#7
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	What spelling of "Available"? You're the guy that can't spell that word. Mantra(don't notice the edit, don't notice the edit....) You're just po'd 'cos I stepped out of my bounds from VBA to "built in function" crap. Actually yesterday, and just for you, I populated Sheet1 with the value "1" in every cell. My machine can handle that, but any data that occupies more than 8 bits is going to crap it out for me. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 10:10 AM	#1
swaink Board Regular Join Date: Feb 2002 Location: South UK Posts: 344	Hi Everyone I have a formula in one cell that returns TRUE/FALSE. If the value is TRUE I want to update a cell on another worksheet to read "Booked" Can anyone Help Kev

Apr 17th, 2002, 10:22 AM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	For arguments sake, let's say that cell A1 on sheet1 is the that will return the TRUE/FALSE value. Let's say that cell B2 on Sheet2 is the cell that's going to say "Booked" or "Available" (or whatever the FALSE text will be) Go to Cell B2 on sheet2 and put in this formula: =IF(Sheet1!A1 = TRUE,"Booked","Available") HTH _________________ [b] Mark O'Brien [ This Message was edited by: Mark O'Brien on 2002-04-17 10:02 ]

Apr 18th, 2002, 03:53 AM	#10
swaink Board Regular Join Date: Feb 2002 Location: South UK Posts: 344	Hi Guys Just to clarify where Im at. On sheet 1 I'm using code and a button, the user will click this button to confirm a bookin. If the button is clicked it will update say cell C9 to read TRUE. Now in another cell (G12) using Aladins formula "Data!"&ADDRESS(MATCH(C12,DATES,0)+2,2)I have obtained the address of a cell on Sheet 2. If the value in C9 is false I don't want to do anything, but if its TRUE then I want the cell on Sheet2 to read "Booked" So Im trying to use the address retreived by the code in G12 as a reference point. Phew I hope that makes sense