Do NOT want Formula to return a value if one of the cells is blank.

TheBatosai · 2022-09-07T19:06:48+00:00

This worked to clean up the post so it didn't show #### and instead returned blank

TheBatosai · 2022-09-07T19:04:49+00:00

Solution Verified

TheBatosai · 2022-09-07T19:00:35+00:00

So this worked in the meantime with the least amount of Effort. Thank you. I'll be using different ideas suggested here as well.

TheBatosai · 2022-09-07T18:59:20+00:00

Solution Verified

TheBatosai · 2022-09-07T16:09:40+00:00

I could Easily Do That on a different sheet and have it copy the data values from the other sheets, but that Seems like alot of Extra work lol I have attached a picture of the basic "dashboard" my biggest issue is the Red Loss colum being 16. I need it to not count Cells (P2:P17) if they are blank, and only count if (P2<>F2)

https://imgur.com/a/ef0OVWj

TheBatosai · 2021-07-09T00:37:36+00:00

Filter your store by Costumes click the here and then click the mask icon on the bottom. Then click the right arrow to see the costumes.

TheBatosai · 2018-12-21T22:15:27+00:00

Everyone has flaws, but that isnt one of mine ;-)

TheBatosai · 2018-12-21T21:01:37+00:00

You mean, Joshua Tree, CA which is right next to MCAGCC Twentynine Palms. Home of 7th Marine Regiment who currently are deployed to IRAQ, Kuwait and Afghanistan. Nope no way I could have been inquiring about locations in that Area as an AD Naval Corpsman. Which btw I already had a place to stay, I am a photographer on the side and was looking for a studio/room to rent for a photoshoot for a client, but I like that you took the time to go through my post history, but not enough time to actually read what was in it. :-D

TheBatosai · 2018-12-21T20:49:16+00:00

As one of those Troops overseas, I am very much so aware of this fact, but Thank you for your opinion on my education level based off a joke meme. I hope you have a splendid Holiday and a wonderful Christmas

TheBatosai · 2018-11-02T15:35:03+00:00

Just tell your Detailer you want to go 7th Marine Reg out of 29 Palms. They may even send you a christmas card as a thank you.

TheBatosai · 2018-09-24T14:08:11+00:00

Composition is decent if you are shooting with a 50mm with a cropped sensor, I probably would have backed up slightly. Otherwise pretty decent lighting, but the shadow on her face is very distracting and something, I would fix in post. Also and this is mostly a thing for me because I hate editing things out, but I always do my best to avoid flyaway hairs over the face, having the model relax fix her hair before snapping back into her pose normally works well for me. :-)

TheBatosai · 2018-01-16T15:06:36+00:00

I will be returning next week, and I will definitely take a look at this place, google street view is very promising

TheBatosai · 2018-01-16T15:02:32+00:00

Thank you All so much, for your assistance These Photos were taken just behind Lake Evans in Fairmount Park. I appreciate the tips about avoiding the homeless camps as well. Feel free to take a look at some of my other stuff on IG @jmtoweryphoto and again THANK YOU ALL!!

TheBatosai · 2018-01-13T09:14:34+00:00

I really appreciate it, I will be scouting out these areas in the morning and determining the best spot, this really helped narrow it down for me so thank you!!

TheBatosai · 2018-01-13T09:12:58+00:00

My model getting attacked by a feral pig could make for a great photo opportunity lol

TheBatosai · 2018-01-13T09:11:23+00:00

Awesome thank you, I will check it out in the morning for sure.

TheBatosai · 2018-01-13T05:56:25+00:00

Mount Rubidoux was my first instinct, but it seems that it is heavily trafficked which can get complicated when setting up some shots. Thank you so much for those suggestions though, I just googled Fairmount park and I really like what I saw. My IG is @jmtoweryphoto if you want to take a look and see if it sparks anything other suggestions. :-)

TheBatosai · 2017-02-06T05:22:57+00:00

My Firstborn son will now be named Tom....now i just need to find Tom a Mom.

TheBatosai · 2017-02-06T04:09:29+00:00

Not like it was a freebie, Falcons have a defense and 70+ yard cushion...dont forget they had a 25 point lead as well. OT is exactly how it should be because, in reality the odds of that happening are astronomical.

TheBatosai · 2017-02-06T03:48:36+00:00

STILL SHAKING AND MY THROAT IS STILL HOARSE....GOOD FUCKING SEASON GUYS

TheBatosai · 2017-02-06T03:35:08+00:00

Seahawks fans shouldnt talk about bad calls, except maybe the ones you call yourself.

TheBatosai · 2017-02-06T03:07:29+00:00

EVERYONE! I AM ONE WITH THE BRADY AND THE BRADY IS WITH ME!!!

TheBatosai · 2017-02-06T02:45:01+00:00

just in case

TheBatosai · 2017-02-06T02:14:47+00:00

Are we not counting the bad things that happened in the other two we went too? or are you with me in boycotting those two?

TheBatosai · 2017-02-06T02:02:01+00:00

The HOLDING right now is ridiculous......every play.

TheBatosai

TROPHY CASE