UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Leave Planner, Office 2013    
 
   
mike60smart
post Dec 4 2019, 08:41 AM
Post#1


UtterAccess VIP
Posts: 13,488
Joined: 6-June 05
From: Dunbar,Scotland


Hi Everyone

In the attached spreadsheet on the Leave Planner Sheet -

Angelina Howe has an Entitlement of 26 Days
She has taken 25 days Leave (V) Plus 2 Half Days (H1 & H2)
Her remaining leave should be 0 but it shows .5 ?

Anyone have any idea why this would be happening?

Any help appreciated

Attached File  Copy_of_Copy_of_SJ_Planner_2019.zip ( 65.75K )Number of downloads: 5

--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
nvogel
post Dec 4 2019, 09:28 AM
Post#2



Posts: 1,040
Joined: 26-January 14
From: London, UK


Some people might be worried that the attachment contains personal information. For the record, it might be a good idea for you to state that the names are not real and any identifiable personal information is removed. Just a thought.

This post has been edited by nvogel: Dec 4 2019, 09:29 AM
Go to the top of the page
 
cheekybuddha
post Dec 4 2019, 09:35 AM
Post#3


UtterAccess Moderator
Posts: 11,908
Joined: 6-December 03
From: Telegraph Hill


Hi Mike,

It's because that's what the formula in cell NW12 (and also all the other NW column formulae) specifies!
CODE
=IF(NJ12=NO12,"0",IF(NJ12>NO12,(NJ12-NO12)-0.5,FALSE))

NJ12 = 26
NO12 = 25

leads to:
CODE
=IF(26=25,"0",IF(26>25,(26-25)-0.5,FALSE))

So, you go to the False part of the first IF:
IF(26>25,(26-25)-0.5,FALSE)

Since 26>25 you go to the True part and return the value:
(26-25)-0.5
Result = 0.5

I reckon the formula needs some adjusting!

--------------------


Regards,

David Marten
Go to the top of the page
 
cheekybuddha
post Dec 4 2019, 09:39 AM
Post#4


UtterAccess Moderator
Posts: 11,908
Joined: 6-December 03
From: Telegraph Hill


Have you checked Peter Hibbs' Holiday Planner db in the Code Archive?

--------------------


Regards,

David Marten
Go to the top of the page
 
mike60smart
post Dec 4 2019, 10:21 AM
Post#5


UtterAccess VIP
Posts: 13,488
Joined: 6-June 05
From: Dunbar,Scotland


Hi David

I just don't understand why it is not working for just this one employee?

How would I modify the formula?


--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
cheekybuddha
post Dec 4 2019, 10:43 AM
Post#6


UtterAccess Moderator
Posts: 11,908
Joined: 6-December 03
From: Telegraph Hill


It's the literal 0.5 that is causing it.

Change the formula in NW7 to:
CODE
=IF(NJ7 = NO7, "0", IF(NJ7 > NO7, (NJ7 - NO7) - (0.5*(NU7 + NT7)), FALSE))

and drag down.

You have your sheet set to not display zeroes. IF you want to see zeroes, then instead use:
CODE
=IF(NJ7 = NO7, "0", IF(NJ7 > NO7, IF((NJ7 - NO7) - (0.5*(NU7 + NT7)) = 0, "0", (NJ7 - NO7) - (0.5*(NU7 + NT7))), FALSE))


hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
mike60smart
post Dec 4 2019, 10:53 AM
Post#7


UtterAccess VIP
Posts: 13,488
Joined: 6-June 05
From: Dunbar,Scotland


Hi David

As usual works a treat

Many thanks yet again

cheers.gif

--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
cheekybuddha
post Dec 4 2019, 11:38 AM
Post#8


UtterAccess Moderator
Posts: 11,908
Joined: 6-December 03
From: Telegraph Hill


yw.gif

--------------------


Regards,

David Marten
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 10:03 AM