If the number is a multiple

[richard1234567891011]

Hello guys,

I have issues in writing a formula that define the multiples. I need a formula like this:
If the number is multiple of another number do put a cell otherwise null ("").
I used the Mod formula in this way:

=SE(MODA(E84;J1)=0;D83;"")


The formula is not working, E84 is 3 and J1 is 3 but the result in this formula is "" instead of D83.

 

[Special-K99]

Change the formula to SE(MODA(3;3)=0;D83;"")
If the result is D83 (as expected) then either E84 is not 3 or J1 is not 3 regardless of if they look like a 3

In blank cells put =E84=3 and =J1=3 to test the values.

 

[richard1234567891011]

SE(MODA(3;3)=0;D83;"") the result is still "".

 

[richard1234567891011]

 

[richard1234567891011]

Thank you very much Special-K99. The issue was in the language, i discovered it. It is a false friend this command in excel. Excel translator is translating bad https://it.excel-translator.de/ricerca/?mssearch=moda. The correct formula in Italian is in this way. Thank you very much.

=SE(RESTO(3;3)=0;D83;"")