Question

Please, Help me with this question, I tried it but It always says #Value.

Here is my problem:

In cell J6, enter a formula to determine the cost of gas if the customer chose that option as indicated in column I. If the customer did not choose the option, then the formula should return zero. Use the named range for cell B44 in this formula. Copy the formula to the range J7:J32.

Answer 1

An #value occurs only when the formula is typed wrongly in the cell. It also shows an error if the reference cell is not available or not accessible. There are multiple reason why #value appears. The following might help to fix the issue.

• There might be a comma encountered instead of using an operator
• Every formula should start with = and there shouldn’t be too much of space before equal sign
• Need to check the alignment before subtracting the date
• Check whether date has been fixed in the system, because excel takes the system date by default.
• Cross verify for usage of special characters