value error_stud calc

Why it is returning #VALUE! error? What is there in F31 and F39?

in F39 when there are no values its causing this VALUE error, but if i have values in F39 then there is no problem.
sometimes there will & other times there wont be values in F39.

Try changing your formula to this:

=IF(F31="","",F31+F39)

Select allOpen in new window

Make sure you don't have text in F31 or F39, that will give you a value error.

Paul

For clarification, no apparent difference between the three options but:

1) F31+F39  - Excel won't recognise and ignore if either of the values is text,
2) SUM(F31+F39) - Although SUM recognises and ignores text values, the use of the + creates a single value within the SUM which creates an error when either is text as per above, SUM then has a single value to sum.
3) SUM(F31,F39) - SUM recognises each item as a separate value and can ignore the text values if/when necessary.