I have this formula =IF(((D11-4)^2*C11/16)=0,"",(D11-4)^2*C11/16)
This works for my purpose, but I want the result to round to the nearest whole number.
I have tried variations of =IF(((D11-4)^2*C11/16)=0,"",ROUND(D11-4)^2*C11/16), 0)) bit can't seem to get anything to work. I'm sure I'm missing something simple here.
Of if there would be a better formula to achieve my results without an error in the cell altogether, any help and suggestions would be much appreciated.
Thanks
Bookmarks