Forum Discussion

mj786's avatar
mj786
Copper Contributor
Oct 26, 2025

Excel conditional formula

Hi i have a problem understanding this  I want to color highlight numbers from row 2 that is row 1 + 5 I mean if any number from row 2 + 5 equal to any number in row 1 to be formatted and fill...
excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 30, 2025
[1, "wxyz", true, 3].map(x => +x + 5)          // => [6, Nan, 6, 8]
[1, "wxyz", true, 3].map(x => Number(x) + 5)   // => [6, Nan, 6, 8]
[1, "wxyz", true, 3].map((x: number) => x + 5)  // => [6, "wxyz5", 6, 8]
[1, 0/0, true, 3].map((x: number) => x + 5)    // => [6, Nan, 6, 8]

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 31, 2025

    At least in Excel environment it shall be

    [1, "wxyz", true, 3].map((x: number) => x + 5) // => [6, wxyz5, 6, 8]

    Yes, editor reports a problem "type string is not assignable to type number" if we use something like

    const abc: number = "abc"

    but actually it works

    console.log(abc + 2, ~~abc + 2)     // => abc2, 2

    On the other hand yes, above is not a good practice which better to avoid.

    Just in case, whatever to number conversion table is here javascript - parseInt vs unary plus, when to use which? - Stack Overflow

Resources