Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2018, 10:38 AM
p45cal's Avatar
p45cal p45cal is offline Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Windows 10 Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

You have
XLEX
absent am, late enrolment,absent pm ??

You also have
LLLE
late am, late pm, late enrolment ??

then should you not also have
XXLE
and


LLEL
??




[and perhaps also XLEL,LLEX?]


or am I missing something?
Reply With Quote
  #2  
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
Reply



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 05:52 PM.


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