Excel pt.(AF72/$CT£12)

[charlie clown]

Help please.

Got a formula in Excel that is not returning the values I expect in all cases.

=IF($A1={"UK""NO""DK"},C1/7.5,C1/8)

A1 is a two-char country code

C1 is a number of hours

7.5 is the working hours per day in countries UK, NO & DK

if the country code isn't UK, NO or DK, then C1 is divided by 8 (the number of working hours per days in every other country. 

At the moment if the value in A1 is UK the formula works, but if it is NO or DK it doesn't. What am I missing?

 

[Redwire]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Nathan Explosion]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[charlie clown]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Senrab_nhoj]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Jay M]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited February 2, 2021 by Jay M