Forum Discussion

olivi44a's avatar
olivi44a
Copper Contributor
Oct 07, 2025

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 

 

excel

2 Replies

  • OlufemiO's avatar
    OlufemiO
    Brass Contributor
    Oct 07, 2025

    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:

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 07, 2025

    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) * A3

    And please update the title of your (should reflect the issue) post that won't help people who search for existing solutions - Thanks

Resources