Ashlee asked in Computers & InternetSoftware · 7 months ago

# 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
• 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.

• DEBS
Lv 7
7 months ago

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.

• 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

• 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

??