In Excel, why does the Formula Result in Function Arguments show an answer but the...

R

Rixor

New member
...result is an error.? When using the formula, "=AVERAGE(ABS(A1:A2)), and there are two different numbers in cells A1 and A2, "#VALUE" shows up on the excel spreadsheet. However, if I open the Function Arguments screen, at the bottom, the Formula Result shows the answer I'm looking for.
 
Back
Top