How to establish if a division result is a whole number

[Tbred]

If am currently trying to establish an IF formula where the True or False revolves around a division result being a whole number.
The If at present is - =(IF('Project Inputs'!$P$14-'Project Inputs'!$P$13<>Assumptions!O9,0,(('Project Inputs'!$P$42*'Project Inputs'!$P$10))))
Row O is a number from 1 through 30.
Project Inputs are number P14 minus P13, in this case the answer is 5. It may be different.
I need to check if the number in row O will divide exactly by the result of P14 minus P13. If it does the resultant multiplication, if not zero.
My formula only works correctly at 5, not for instance 15 or 25.
Help greatly appreciated, I hope I have explained clearly enough.

 

[Candyman8019]

You'll likely be looking for the MOD function here. It will provide the remainder for a division equation. For example:

=IF(MOD('Project Inputs'!$P$14-'Project Inputs'!$P$13,Assumptions!O9)=0,"whole","not whole")

 

[Fluff]

Another option

=('Project Inputs'!$P$42*'Project Inputs'!$P$10)*(mod('Project Inputs'!$P$14-'Project Inputs'!$P$13,O9)=0)

 

[Tbred]

You'll likely be looking for the MOD function here. It will provide the remainder for a division equation. For example:

=IF(MOD('Project Inputs'!$P$14-'Project Inputs'!$P$13,Assumptions!O9)=0,"whole","not whole")

Thanks for your quick reply Candyman. I gave your suggestion a try. I seem to be encountering the same problem. When I get to O9 which is the number 5, I get "whole". However, when I reach X9 and the number in that cell is 10, I get "Not Whole" when I would need it to be "Whole". Maybe it is my poor explanation. Thanks anyway.

 

[Tbred]

Thanks Fluff, with your help worked it out.
=(IF(MOD(O9,('Project Inputs'!$P$14-'Project Inputs'!$P$13)),0,(('Project Inputs'!$P$42*'Project Inputs'!$P$10))))

 

[Fluff]

Glad we could help & thanks for the feedback.