Loading ...
Sorry, an error occurred while loading the content.
 

Re: [PCGenListFileHelp]Need some help with JEP define question

Expand Messages
  • Éric Beaudoin
    ... expression.INTVAL is the old formula parser (from before JEP) way s to floor the value i.e. to only keep the integer part of the value. I believe you could
    Message 1 of 3 , Sep 22, 2005
      At 23:27 2005.09.22, Terry FitzSimons wrote:
      >Original-recipient: rfc822;beaudoer@...
      >
      >I'm trying to gather various formulas for REF, WIL, BAB, FORT, ect.
      >
      >I've run into a formula that I can't define and that Excell chokes on.
      >
      >1+((CL/5).INTVAL)+(((CL+3)/5).INTVAL)
      >
      >Can't find a define for it in the JEP page http://www.singularsys.com/jep/
      >so can someone tell me what INTVAL means/
      >
      >Thank you for your time.

      expression.INTVAL is the old formula parser (from before JEP) way's to floor the value i.e. to only keep the integer part of the value.

      I believe you could use this in Excel:

      1+FLOOR(CL/5,0)+FLOOR((CL+3)/5,0)

      Best


      -----------------------------------------------------------
      Éric "Space Monkey" Beaudoin
      Founding Member of the Hidden-in-the-Trench Club
      Release Monkey and Syntax Watchdog
      >> In space, no one can hear you sleep.
      >> Camels to can climb trees (and sometime eat them).
      <mailto:beaudoer@...>
    Your message has been successfully submitted and would be delivered to recipients shortly.