Forum Discussion
62Mojo
Apr 19, 2023Copper Contributor
Formula returning #value
Hello, I have an error when trying to calculate a value if certain criteria is met. I'm using Excel 2016 (home/student). The formula used for the calculation is =IF(SUM(G31:G32)>0,SUM(G31*0.5...
- Apr 19, 2023I did open the file and G32 is not a number so you need to address that. Here is an alternative:
=IF(SUM(G31:G32)>0,SUM(G31)*0.5+SUM(G32),"")
in this case SUM is used to ignore blank/text. notice I also pulled *0.5 outside the SUM even though that wasn't the problem it could be
Patrick2788
Apr 19, 2023Silver Contributor
Go to G32 and clear contents. You've got a space in that cell.
- 62MojoApr 19, 2023Copper ContributorThank you for catching that. The issue is now resolved.