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!
- RoddyLv 71 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.
- D.E.B.S.Lv 71 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.
- expletive_xomLv 71 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
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.
- MamiankaLv 71 year ago
(B4+B5) needs to be in parentheses.