Recent content by Rixor

  1. R

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

    ...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