Re: Excel MOD Function in InfoPath

wilkies0106aw — Mon, 09 May 2016 14:12:57 GMT

This can be done.

You'll need some helper fields (naturally)

Fields, LargeNumber, SmallNumber,Mod,Result

Mod has the following default value LargeNumber mod SmallNumber

I added 2 rule to the smaller number field

1. Condition: if mod = 0 set result field to yes.

2. Condition: if mod NOT equal 0 set result field to no

Excel MOD Function in InfoPath

wilkies0106aw — Thu, 28 Apr 2016 15:20:02 GMT

All,

I've a field with a single small value which can be up to 2 decimal places i.e. 5.50

I've another field (total ) with a much lager value i.e. 147. Can InfoPath do the equivalent of an excel MOD function. i.e. =IF(MOD(A1,B1)=0,"yes","no") ?

A1 being my larger number, B1 being my smaller number.

I'm not always going to know the smaller number so a quick math formula on the form would help.

Thanks

General

Re: Excel MOD Function in InfoPath

Excel MOD Function in InfoPath