Forum Discussion
Halle Hughes
Oct 01, 2018Copper Contributor
Please help with #REF! error
I have tried to using excel to complete a function for an operations management class but when I type the formula and press enter, #REF! appears and I cannot seem to find what is wrong with my formula. Please let me know if you can help me solve this problem! The function I entered was: =(A2)(B2)(C2)(D2)-(B2)(C2)(E2)-G2
I attached the excel file below, feel free to edit or comment tips!
1 Reply
- SergeiBaklanDiamond Contributor
Hi Halle,
That is
=A2*B2*C2*D2-B2*C2*E2-G2