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
/board/images/smiles/icon_confused.gif
=IF(Sheet1!A1 = TRUE,"Booked","Avaliable")
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.
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
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.