How to insert picture to Google Sheet to have it show up in the cell

In the Google sheet cell type like following

=image("https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsqXLO_m3Do-XLeNyV3lk06wHN73C3b2qTm98I1n4ZFl9Fde34GOevVgHuTK0PpRE6dr5gCG6o2DRAIE5fnoLlwUHxYcyowDNuzPYJzGu05qpjncjiAHFW9eVC5aYzMAhFrr4mpD6ruHMy/w945-h600-p-k-no-nu/door.JPG,4,300,300)")

URL must be have picture extension at the end. I just use Blogger posts which has the picture and copy the image link address

4,300,300)

4 must be used if need to specify width and height in pixels