Forum Discussion
help
hi im still pretty new to excel so im very confused i keep getting the #REF! error for this equation but im not sure why, i dont have any deleted cells or anything that google is telling me. thankyou...
Hi olivi44a,
The #REF! error appears because your formula is missing a multiplication sign.
You wrote:
=$C$2(1-A3/$D$2)*A3
It should be:
=$C$2*(1-A3/$D$2)*A3
Excel reads $C$2(…) as trying to call a function, which doesn’t exist, so it returns #REF!.
Adding the * fixes it.
Here’s what your table should look like once the formula works:
