INSERT AN IMAGE INTO AN EXCEL CELL WITH A FORMULA!

 INSERT AN IMAGE INTO An EXCEL CELL WITH A FORMULA! 

I want to react to this title with 4-year-old my son’s words: “oh come on, don’t exaggerate like this.” 😊

So, what does it exactly do? What do we use it for?

The IMAGE function has been designed to add an image into a cell from a URL.

Which file extensions does it support?

BMP, JPG/JPEG, GIF, TIFF,ICO,PNG are the extensions that it supports as of now.

Since it is brand new, I want to talk about it in detail:

The function has 5 parameters. Our regular readers here know this but for those with whom our paths have never crossed, I want to reiterate:

In a function, the parameters that with write in [] are optional. But those that are not written in square brackets must be written.

Now let’s go ahead and take a look at our formula:

=IMAGE(source, [alt_text], [sizing], [height], [width])

 SOURCE                  : URL path of the image file, using an “https” protocol
 ALT TEXT (Optional)    : Alternative text that describes the image
 SIZING (Optional)      : Defines the size.
 HEIGHT (Optional)          : Defines the height.
 WIDTH (Optional)         : Defines the width.

.

For example, if you write the formula down below into a cell in Excel,

=IMAGE(https://cdn.ablebits.com/_img-blog/image-function/items/water.jpg;Okyanus)

you will see a picture of an ocean.

Let’s say that you have a list consisting of Product Names, Stock Information and Prices. It wouldn’t be so bad to have the images of these products next to them using the IMAGE function, would it? 😊

A not-so-famous philosopher (That is no one but me😊) once said: “ Visualizing the data is just as important as preparing it.”

.

.