# 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!

Relevance
• 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

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