Is there an easier way to do this if_else_then statement

[kinder]

Hi,

Is there an easier way to do this if_else_then statement


befoe i add in the code, what tags do i need to put on the code?

[dominicb]

Good afternoon kinder

Just click on the "#" button in the toolbar just above your thread main window - only visible when you're composing a post.

Or add this tag at the start :
{CODE}
and this tag at the end
{/CODE}
(but replace {} with [])

HTH

DominicB

[royUK]

Paste your code into the answer window, select it and click # in the Toolbar above.

If you haven't got this Toolbar displayed then type [code] before your code snippet and at the end type [ /code] - note no spaces.

[kinder]

Please Login or Register  to view this content.

[royUK]

What about

Please Login or Register  to view this content.

[kinder]

Thanks.

I have gathererd if i want a career in Excel/vba i guess it's easier to figure it out myself.

Thanks anyway, i will try your code later and read up on how it works.

[royUK]

It's simple. You seem to have a maximum of 50 hours, so you set chk as 50 then if chk is greater than hour is greater than 50, you deduct chk from hour which leaves the number of hours over 50 which leaves 50. This would work as well. Defining chk as a Const just makes management of the code easier, you only ned to change the value of the constant.

Please Login or Register  to view this content.

[kinder]

I have a deadline to do this and my code is working, i know it's rubbish for the long run but my manager don't know that.

I will use your code and change it next week, thanks

[royUK]

Check your code, it has some duplicates in.

[kinder]

Well spotted