Question about EXCEL: I am trying to do an equation stating: IF C3 = "Monday" THEN B3=B4+B5 but it all keeps coming up #REF or error?

I don t need a true / false equation. I need to to add for me... help? Thank you in advance!

5 Answers

Relevance
  • Roddy
    Lv 7
    1 year ago

    The result of your function affects the cell into which you type it. You cannot affect a 'remote' cell (such as C25 in your case) from within the function.

  • 1 year ago

    Your statement: =IF(G3="Monday", C25=(F25*B25))

    It appears that you're trying to state which cell should have the result. You can't do that. The result is in the cell you have the formula in. So instead of saying... C25=(F25*B25)....you should have this formula in cell C25 and state =If(G3="Monday",F25*B25,0) In words, that is "If G3 equals Monday, then F25 times B25, else 0." The else 0 is not required, but if you don't have it and G23 is not Monday, then you would get the result of 'FALSE' returned.

  • 1 year ago

    you dont say what you want if you get a False.

    you want to put your formula in cell C25 and adjust it this way

    =IF(G3="Monday",F25*B25,"")

    that way If its true that G3 is Monday then it will do your calculation....but if G3 is False then C25 will go blank.

    i had to guess on the False, but let me know how it works

  • 1 year ago

    This is my equation: =IF(G3="Monday", C25=(F25*B25))

    Still says FALSE and #REF when i try and move cells around

    ??

  • How do you think about the answers? You can sign in to vote the answer.
  • 1 year ago

    (B4+B5) needs to be in parentheses.

Still have questions? Get your answers by asking now.