Excel MOD Function in InfoPath - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Excel MOD Function in InfoPath

Last post 05-09-2016 07:12 AM by wilkies0106aw. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-28-2016 08:20 AM

    Excel MOD Function in InfoPath

    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

     

     

     

    Filed under:
  • 05-09-2016 07:12 AM In reply to

    Re: Excel MOD Function in InfoPath

     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 

     

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.