Hi can someone help me out please, tried different formulas none give the right result
the result depends on 2 cells P13 and P27,
P27 "working" "lunch"or "" (empty)
P13 can be "FREE" or "BUSY"
the result gets value copied in P13 (macro)
conditions :
P13 P27 Result
FREE (empty) FREE
FREE working BUSY
FREE lunch FREE
BUSY (empty) BUSY
BUSY lunch FREE
The result gets a value copy paste in cell P13 (by macro on timer)
formulas I wrote :
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
best ones working where :Please Login or Register to view this content.
this one works good except condition 2, cause if he change P13 free to trade then te same formula change back to freePlease Login or Register to view this content.
In fact what I want is : if p27 change to working, he put "BUSY" and hold this until "lunch" come.
if so : change BUSY to FREE
sometimes "lunch" comes without a "BUSY" before, he should keep on FREE
Great thanks for help me out
Chris
Bookmarks