If you are writing a formula that references a closed Excel workbook, your external reference must include the workbook name and entire path to the workbook.
For example: For more information, please see Creating a reference to another workbook.
Most of us are used to separating function arguments with commas. The character you use to separate arguments depends on the List Separator set in your Regional Settings.
Remember that in Excel formulas, a comma is typically used to separate a function's arguments, and the dollar sign makes an absolute cell reference.
For instance, instead of entering ,000 in your formula, input simply 50000, and use the ) to format the output to your liking.
Don't worry, most likely your Excel is all right, and you will get all the answers in a moment.
: Excel formula not working correctly, it returns an error or a wrong result.