SOLVED

New Contributor

# Formula not working correctly and not reading calculated number

I'm not overly good at formulas in Excel, so I tried to make something simple but I'm still having issues. Hoping someone can help.

Box 1: C9      Box 2: D9     Box 3: E9   Box 4: F9    Box 5: G9

Formula is F9 is =IMSUB(C9,D9) Goal: to take C9-D9=F9 this is correct except it’s not showing up as \$ even though currency is selected. Also tried changing to accounting. No \$ added.

Box G9 should be calculating E9+F9=G9 and it’s not correct. Formula is currently =SUM(E9,F9). I’ve also tried =SUM(E9:F9). It seems to not be picking up the calculated amount from F9.

This is the bottom of the worksheet. Where you see the \$0.00 this should be taking the sum of the numbers in F row. This shows it’s not seeing the calculated response from F9 and not taking it into account into other formulas. How do I fix this? Thanks!

5 Replies

# Re: Formula not working correctly and not reading calculated number

best response confirmed by Aurora_GS (New Contributor)
Solution

# Re: Formula not working correctly and not reading calculated number

IMSUB returns difference of two complex numbers as text, not as scalar number (complex numbers are returned as text). It looks like you keep it in F9 since most probably you have text in this cell.

# Re: Formula not working correctly and not reading calculated number

@Sergei Baklan Thank you. This makes sense. I actually had someone figure this out for me a short while ago. I had to remove the IMSUB for it to work ok. I changed the formula to =SUM(C9-D9) and that worked and then I changed my other formula to =SUM(E9+F9).

# Re: Formula not working correctly and not reading calculated number

Thank you I got it figure out.

# Re: Formula not working correctly and not reading calculated number

Please note that your formula =SUM(E9+F9) is not entirely correct. It should be either =E9+F9 or =SUM(E9,F9)