read tutorials, but am constantly stuck

[litifeta]

Hey all. Been using excel with mixed success, but get really confused when I have to do multiple arguments.

(ie) Cell A1 has a destination possibility ... let's say either New York, London or whatever.

B1 has a time ... :-> :->

In cell C1 I wanted to write a formula that said If A1 = New York, and if the time was before 6.30 am, a value would appear in the cell.

BUT ...

If the word in A1 was not New York, but was before 6.30am, a different value would appear.

 

[Derek]

FORMULA DIDN'T POST - DELETED

 

[sunnyland]

Hello Litifeta & Derek,

Sorry, but somehow the formula wouldn't paste


Regards

Francoise

 

[sunnyland]

Hello Litifeta & Derek,

Try this[click on the copy formula on the left corner of HtmlMaker

Book5
	A	B	C	D
1	NewYork	6:29	NewYorkbefore6:30
Sheet1

Your time will have to be entered in the cell as 5:30

***Hie, Derek, something weird happened when I tried to enter the formula and probably same thing happened to you has I saw your previous post
Regards

Francoise[/quote]