Hi everyone,

I currently have a formula which is added the results of 8 vlookups together. What I would like is to add an if statement in the cell which states that if the result is greater than 1000 then the result will show as 1000, otherwise the result should be what the additional formula comes out to. I tried if(Y4>1000,1000,y4) but I got an error. Any thoughts?

Thanks!