Forum Discussion
Solved
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...
- I 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
Do what Patrick suggested and your existing formula will work.
Btw you have used the SUM function in the wrong way, try it like this and your formula will work. The advantage of using the SUM function as suggested below is, it ignores the text values.
=IF(SUM(G31:G32)>0,SUM(G31*0.5,G32),"")- Thanks for the response and the advice. The issue is now resolved.
