Forum Discussion
excel
Hello, I am having trouble making a spreadsheet! In column C3 I insert a quantity that in C4 should calculate only when J7 turns negative (like in image -1). Could someone help, please?! ---...
=SI(J7<0;C3*J16;"")=SE(J7<0;C3*J16;"")It didn't work, the J7 column when it becomes negative and green, you must calculate the C4 column multiplied by the amount of C3