excel formula

[kamranyd]

=IF(OR(M6>0, N6>0),($M$1+SUM($M$6:M6))-SUM($N$6:N6),"")

is there any other formula who can do this type of calculation or any other way to do it because this formula give error.

 

[mole999]

What is the error, what is the cause?

 

[kamranyd]

Im using office 2016. formula is working but it give green color tag in a cell to correct error or update formula why?

 

[mole999]

A green triangle in the upper-left corner of a cell indicates an error in the formula in the cell. If you select the cell, the Trace Error

button appears. Click the arrow next to the button for a list of options.

> https://support.office.com/en-gb/ar...my-cells-203e34e6-ba90-4158-ae58-33397dda3ca9