Conditioning of IF formula

[Koejns]

After my success with yesterdays question on this forum I have a new question. I have made the function:
IF(OR(B32/'Project specific input'!$C$26=1;B32/'Project specific input'!$C$26=2;B32/'Project specific input'!$C$26=3;B32/'Project specific input'!$C$26=4;B32/'Project specific input'!$C$26=5;B32/'Project specific input'!$C$26=6;B32/'Project specific input'!$C$26=7;B32/'Project specific input'!$C$26=8;B32/'Project specific input'!$C$26=9;B32/'Project specific input'!$C$26=10);((Calculation!$C$101))/NPV!C32;0)

It works propperly but I want to make it smaller and I think excel can do this for me. The function uses a list of numbers (1 to 20)(that is the B32 number) and devides that by 4. Now I only want Excel to give me an answer when the list number devided by four is a multiple of 1. So when it comes to 7/4 it should return 0 and when it comes to 8/4 it should return the (Calculation!$C$101))/NPV!C32 answer.

How can I make this more practical?

 

[jasonb75]

Try

=if(mod(b32,4),0,b32/'project specific input'!$C$26)

 

[Koejns]

Thanx! It works 2nd case closed!