I have used the Excel ... formula, meaning it was carried over from the formula entered in cell K2. If you wish to modify the formula for this customer, you will need to make those changes in cell K2.

Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number. This can be hard-coded inside double quotes or a reference to a cell ...

While you're playing around with the settings in Excel, consider switching to dark mode. If you spend all day staring at spreadsheets and find the white Excel canvas gives you a headache, switching to ...