Forum Discussion
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...
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.
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