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
Not sure what you intention is in term of calc. but the #REF! error you get is due to a missing operator between =$C$2 and (. Try:
=$C$2 * (1 - A3 / $D$2) * A3And please update the title of your (should reflect the issue) post that won't help people who search for existing solutions - Thanks