Using =IF(D4+D3>0,D4+D3,"Z") is there a way that I could replace D4+D3 with the highest value ?
Lets say that D4+D3 was above 0 then is there a way to have the value in the cell equal to the highest value in area D3:D10.
Sorry about the poor explanation,
Adam.
Bookmarks