Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 10-30-2018, 02:32 AM
Marcia's Avatar
Marcia Marcia is offline Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Windows 7 32bit Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Office 2007
Expert
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

XLEX = is absent am, late enrolment, absent pm
Scrap LLLE, it should be LLEL = Late am, late enrolment, late pm (consistent with XLEX code sequence)

Scrap LLTI, it should be LTIL = late am, Transfer In, late pm (consistent with XLEX code sequence)

You're right, please add:
XLEL = Absent am, late enrolment, late pm
LLEX = Late am, late enrolment, absent pm
XTIL = absent am, Transfer In, late pm
LTIX = Late am, Transfer In, absent pm
TIX = absent pm, Transfer In ( so that the X will fall on the right triangle)
LEX = absent pm, late enrolment



THANK YOU!!! There's power outage so I might not be able to respond to any further clarifications tonight.

Last edited by Marcia; 10-30-2018 at 10:56 PM. Reason: Removed quote
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
New learner need help - convert tables in word format to ppt slides. sas Word VBA 5 09-21-2017 08:33 PM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Good morning/afternoon/evening based on time dwirony Word VBA 1 01-03-2017 01:01 PM
Need conditional formatting formula namedujour Excel 1 05-27-2016 08:58 AM
Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Conditional Formatting Formula teza2k06 Excel 1 08-22-2014 02:49 AM
Conditional Formula UICOMP Excel 1 05-18-2012 12:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft