IF function gives a circle reference

  • Hi dear forum


    I´m working on a IF formula where if H9 is negative i.e < 0 then

    Code
    H9=0

    otherwise

    Code
    H9=(D4+D5+D6+D7+D8)-C27-C32-C28


    but i keep geeting error message

    Code
    =IF(H9 < 0;0;"=(D4+D5+D6+D7[+D8)-C27-C32-C28")


    Quote

    one or more circular references where a formula refers to its own cell either directly or indirectly. this might cause these to calculate incorrectly

    Please help me solve this issue.
    Any help will be appriciated


    With Regards


    Peter, from Sweden

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!