How to Return an Empty Cell When the Value is Zero in Google Sheets

If you’re anything like me, you want clean data and don’t want to show anything that may look wrong. In this instance, I have rows of data, but some rows may not have data yet and I want them to be ready for when they do have data. Instead of showing 0 for every field with no data, you can return an empty cell. Here’s how. In the cell you want to show the empty cell when no data, you first run the calculation to see if it returns any data. If it does, then show that data. If it …

Continue ReadingHow to Return an Empty Cell When the Value is Zero in Google Sheets

Augmented Reality. Gaming, Tech, Real Life

I’ve been casual gamer since I was about 8 years old when I was first introduced to computers. I played a really mean game of Oregon Trail on my Apple II E at school. My first computer had the blazing processing speed of 100mhz. I’ve seen a lot happen both in computers and gaming since then.

Augmented reality, also called “mixed reality,” is finally becoming a reality for the world. Virtual reality was around in the 90s, but never took off because of the high cost to entry for consumers, as well as a massive lack of content available even if you could buy the hardware. Thankfully with today’s breakthroughs in technology, that’s all changing.

Continue ReadingAugmented Reality. Gaming, Tech, Real Life

Fast & Exotic Cars of Newport Beach

I decided to take my camera out early this morning and grab some snaps at an auto show nearby here in Newport Beach. Cars were amazing, people were amazing.

I went to a seminar recently at Canon’s Live Learning here in Coasta Mesa about focal points and I wanted to try something different for this photo shoot. I primarily focused my photos at 17mm with my Canon 17-55mm lens, which gives it the wider view.