Aeperate sheet functions
Quick question… I am designing a schedule for my work. It is designed to cut out a half hour for a break if a shift lasts longer than 6 hours. This function works great. However, I want a separate cell to display the word “break” for shifts over 6 hours. On a separate page I am using this command: =IF(A1<=6,"", "Break") This will display "break" on the second page, but not on the schedule itself. On the cells i want "" or "break" displayed i get a "0". I am using =SUM(sheet2!A22). Any ideas?
File attached.... Thanks!!!!
Shuffledew
Last edited by shuffledew; 10-20-2010 at 09:19 PM. Reason: adding info
See attached.
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Thank you!!!!!!!!!!!!!!
No problem.
**Please mark your post [SOLVED] if it has been answered satisfactorily.
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks