Problem with IIF condition

[Unicon]

Dear all,

Please see the attachment. I want to get a NormalDays from ANormalDays. I want to make 26 days in NormalDays If ANormalDays is 26 or 27.
I put a condition like that but showing that Query is too complex.

Please advice.

 

[Galaxiom]

That expression asks if the value is 27 only if the value is 26 in the previous part of the test. Obviously this is not going to do anything useful.

IIF(ANormalDays=26 OR ANormalDays=27, 26, ANormalDays)

If the ANormalDays cannot exceed 27 then just use use:
IIF(ANormalDays>=26, 26, ANormalDays)