Solved Quotient with N/A value

[Valient]

Hi AW Team,
Good day.

I would like to ask your assistance again regarding the code.

In the FORM under DATA , CONTROL SOURCE,
I use the below code to get the quotient value of T1 and T2
=[T1]/[T2]

It works fine as per the code if both T1 and T2 has number value. However, If the value is "N/A" it display "#Type!"

Can you please help to improve the code by: If the value is "N/A", the display should also be "N/A

 

[cheekybuddha]

What have you tried?

Build upon the ideas in your other threads.

Test your values, and perform the calculation if required.

=IIf([T1] = "N/A" OR [T2] = "N/A", "N/A", [T1]/[T2])

 

[Valient]

What have you tried?

Build upon the ideas in your other threads.

Test your values, and perform the calculation if required.

=IIf([T1] = "N/A" OR [T2] = "N/A", "N/A", [T1]/[T2])

Thank you very much