Forum Discussion

Brass Contributor

Dec 07, 2021

Solved

Sum cells with formula

I have built a performance tracker where an Exceed gets 1 , Meet gets 0.75 and below gets 0.40 . The issue is it will not let me sum it because the formula is read as a text Thie is the formula I u...

excel

Juliano-Petrukio

Dec 07, 2021

Remove the double quotes from your numbers in the formula.

=IF(ISNUMBER(SEARCH("Exceed",E2)),1,
    IF(ISNUMBER(SEARCH("Meet",E2)),0.75,
     IF(ISNUMBER(SEARCH("Below",E2)),0.4,IF(ISNUMBER(SEARCH("TBD",E2)),""))))

Juliano-Petrukio

Bronze Contributor

Dec 07, 2021

Remove the double quotes from your numbers in the formula.

=IF(ISNUMBER(SEARCH("Exceed",E2)),1,
    IF(ISNUMBER(SEARCH("Meet",E2)),0.75,
     IF(ISNUMBER(SEARCH("Below",E2)),0.4,IF(ISNUMBER(SEARCH("TBD",E2)),""))))