Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

As long as there isn't a clear specification of the assignment of secondary codes to the primary ones I cannot offer "positive" advice.

Negative: All your conditional expressions are of the type IF(Condition;Number) and thus incomplete: The else part is missing. The IF function must nonetheless return something also if the condition comes out FALSE. In the absence of the else (otherwise) part this will be the FALSE itself treated a 0 (zero) by the automatic conversion into text.

Generally consider a basical redesign of your attempts.

(The usage of fractional numbers for the secondary codes is a mystery to me. I cannot reasonably guess what you actually want to achieve. If you want to assign explicitly one specific code to any allowed input: Dispose the IF-chain and use a lookup-table. )

As long as there isn't a clear specification of the assignment of secondary codes to the primary ones I cannot offer "positive" advice.

Negative: All your conditional expressions are of the type IF(Condition;Number) and thus incomplete: The else part is missing. The IF function must nonetheless return something also if the condition comes out FALSE. In the absence of the else (otherwise) part this will be the FALSE itself treated a 0 (zero) by the automatic conversion into text.

Generally consider a basical redesign of your attempts.

(The usage of fractional numbers for the secondary codes is a mystery to me. I cannot reasonably guess what you actually want to achieve. If you want to assign explicitly one specific code to any allowed input: Dispose of the IF-chain and use a lookup-table. )

As long as there isn't a clear specification of the assignment of secondary codes to the primary ones I cannot offer "positive" advice.

Negative: All your conditional expressions are of the type IF(Condition;Number) and thus incomplete: The else part is missing. The IF function must nonetheless return something also if the condition comes out FALSE. In the absence of the else (otherwise) part this will be the FALSE itself treated a as 0 (zero) by the automatic conversion into text.

Generally consider a basical redesign of your attempts.

(The usage of fractional numbers for the secondary codes is a mystery to me. I cannot reasonably guess what you actually want to achieve. If you want to assign explicitly one specific code to any allowed input: Dispose of the IF-chain and use a lookup-table. )

As long as there isn't a clear specification of the assignment of secondary codes to the primary ones I cannot offer "positive" advice.

Negative: All your conditional expressions are of the type IF(Condition;Number) and thus incomplete: The else part is missing. The IF function must nonetheless return something also if the condition comes out FALSE. In the absence of the else (otherwise) part this will be the FALSE itself treated as 0 (zero) by the automatic conversion into text.

Generally consider a basical redesign of your attempts.

(The usage of fractional numbers for the secondary codes is a mystery to me. I cannot reasonably guess what you actually want to achieve. If you want to assign explicitly one specific code to any allowed input: Dispose of the IF-chain and use a lookup-table. ))

Edit: Decided to attach this example I made yesterday.