I'm trying to do a nested IF Statement. I have a column with different text categories and would like to output an outcome based on the text. Here is an example, if "NISMO" in B2, then output "images/custom/nismo-hero.jpg". I thought this would work but it doesn't --- =IF(B2="Nismo","images/custom/nismo-hero.jpg",""). If using just text is possible, I'd like to create multiple rules so I have a IF Statement for every category. So is it possible to nest these statements?