How to embed Google Drive images in Google Sheets

How do you embed an image from Google Drive into a Google Sheets Spreadsheet?

=IMAGE(SUBSTITUTE("shareable_link","https://drive.google.com/open?id=","https://docs.google.com/uc?export=download&id="))

Use the formula above and replace “shareable_link” with the shareable link from your desired image.