New Topic/Question
Reply
I'm trying to modify a sheduling spreadsheet that is used in the restaurant I work in. Basically if a person is scheduled I want their name to display on a Deployment Sheet. The way the schedule is set up the hours are entered in 5 - cl, 4 - 9, 5 - 3. I can't seem to get the code right. How can I get it to say If any value is entered in this cell then display that persons name.
1 Replies - 2551 Views - Last Post: 26 May 2007 - 10:29 AM
Rate Topic:
#1
rollinhard
- D.I.C Head
Reputation: 1
- Posts: 64
- Joined: 13-February 05
if/then statement in excel
Posted 26 May 2007 - 10:26 AM
Is This A Good Question/Topic?
0
MultiQuoteReplies To: if/then statement in excel
#2
no2pencil
- Original Digital Gansta
-
Reputation: 4503
- Posts: 24,970
- Joined: 10-May 07
Re: if/then statement in excel
Posted 26 May 2007 - 10:29 AM
rollinhard, on 26 May, 2007 - 10:26 AM, said:
I'm trying to modify a sheduling spreadsheet that is used in the restaurant I work in. Basically if a person is scheduled I want their name to display on a Deployment Sheet. The way the schedule is set up the hours are entered in 5 - cl, 4 - 9, 5 - 3. I can't seem to get the code right. How can I get it to say If any value is entered in this cell then display that persons name.
=IF(C1<>"",C1,"None")
Change C1 to correct Cell.
Was This Post Helpful?
0
Page 1 of 1
|
|
| 