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
    7 months 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.

    • Login to reply the answers
  • DEBS
    Lv 7
    7 months 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.

    • Login to reply the answers
  • 7 months 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

    • Login to reply the answers
  • 7 months ago

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

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

    ??

    • Login to reply the answers
  • How do you think about the answers? You can sign in to vote the answer.
  • 7 months ago

    (B4+B5) needs to be in parentheses.

    • Login to reply the answers
Still have questions? Get your answers by asking now.