Forum Discussion
dsdans
Jun 22, 2025Copper Contributor
Excel IF/IFS formula not calculating scenario "B"
Hi, Hopefully an easy solution that's staring me in the face, but I've been trying to fix this for an hour and I'm getting nowhere. Any pointers appreciated. I've been working on a new calculato...
SergeiBaklan
Jun 24, 2025Diamond Contributor
It depends. If in N52 and N57 we have "1" and "2" (not 1 and 2), when SUM(N52+N57) gives 3. SUM(N52,N57) returns zero.
Without file or at least screenshot that's only guesses.
m_tarler
Jun 24, 2025Bronze Contributor
that is an excellent point that TEXT that can be interpreted as numbers will be evalutaed using + while SUM will ignore. But I still don't see a case for having both. how is SUM(N52+N57) any different than N52+N57