Skip to content

Instantly share code, notes, and snippets.

@LeonardoDSSilva

LeonardoDSSilva/Advanced Formula Environment

Last active March 31, 2022 13:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save LeonardoDSSilva/e867bce5177cdf926e250651d6ed1ece to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save LeonardoDSSilva/e867bce5177cdf926e250651d6ed1ece to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. LeonardoDSSilva revised this gist Mar 31, 2022. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions Advanced Formula Environment
    View file
    Original file line number Diff line number Diff line change
    @@ -7,6 +7,6 @@ SUMARIZACAO = LAMBDA(a,b, c, d,(
    ));

    DOT = LAMBDA(num,
    (RIGHT(num, 3) & "." &
    LEFT(num, 3))
    (LEFT(num, 3) & "." &
    RIGHT(num, 3))
    )
  2. LeonardoDSSilva revised this gist Mar 31, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion Advanced Formula Environment
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@ SUMARIZACAO = LAMBDA(a,b, c, d,(
    ISBLANK(c),"","."& IF(LEN(c)=1, "00" & c , "0" & c)),IF(
    ISBLANK(d),"","."& IF(LEN(d)=1, "00" & d , "0" & d)
    ))
    )),
    ));

    DOT = LAMBDA(num,
    (RIGHT(num, 3) & "." &
  3. LeonardoDSSilva revised this gist Mar 31, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion Advanced Formula Environment
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@ SUMARIZACAO = LAMBDA(a,b, c, d,(
    ISBLANK(c),"","."& IF(LEN(c)=1, "00" & c , "0" & c)),IF(
    ISBLANK(d),"","."& IF(LEN(d)=1, "00" & d , "0" & d)
    ))
    ))
    )),

    DOT = LAMBDA(num,
    (RIGHT(num, 3) & "." &
  4. LeonardoDSSilva revised this gist Mar 31, 2022. 1 changed file with 6 additions and 1 deletion.
    7 changes: 6 additions & 1 deletion Advanced Formula Environment
    View file
    Original file line number Diff line number Diff line change
    @@ -4,4 +4,9 @@ SUMARIZACAO = LAMBDA(a,b, c, d,(
    ISBLANK(c),"","."& IF(LEN(c)=1, "00" & c , "0" & c)),IF(
    ISBLANK(d),"","."& IF(LEN(d)=1, "00" & d , "0" & d)
    ))
    ))
    ))

    DOT = LAMBDA(num,
    (RIGHT(num, 3) & "." &
    LEFT(num, 3))
    )
  5. LeonardoDSSilva created this gist Mar 21, 2022.
    7 changes: 7 additions & 0 deletions Advanced Formula Environment
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,7 @@
    SUMARIZACAO = LAMBDA(a,b, c, d,(
    CONCAT("0",a,".",IF(
    LEN(b)=1, "00" & b , "0" & b),IF(
    ISBLANK(c),"","."& IF(LEN(c)=1, "00" & c , "0" & c)),IF(
    ISBLANK(d),"","."& IF(LEN(d)=1, "00" & d , "0" & d)
    ))
    ))