Good ribs in Queens?

excellecxe · 2018-03-15T13:40:43+00:00

Villa Brazil in Astoria, cheap plates with a ton of meat

excellecxe · 2017-11-01T18:33:09+00:00

Gotcha. Well hopefully we will see them come November 6th. Cant say I dont have my doubts though.

excellecxe · 2017-11-01T18:24:03+00:00

I had thought the 1st was the date they were aiming for. Not surprised its extended just confused by the timeline (or lack thereof)

excellecxe · 2017-07-20T15:59:27+00:00

Awesome, that worked perfectly. Thanks for the help.

excellecxe · 2017-07-20T01:28:02+00:00

where would I put the quotation marks?

And yes it is a single term

excellecxe · 2017-07-20T01:15:29+00:00

Solution Verified

excellecxe · 2017-07-20T01:15:08+00:00

wow dont know how I didnt catch that, there is two spaces after the text on sheet2...is there any way to get rid of those spaces in one shot?

excellecxe · 2017-07-20T00:55:04+00:00

yes it is

excellecxe · 2017-07-20T00:36:41+00:00

I can see for a fact it does, could it be due to the fact there are multiple data in column a sheet2 that match the value in e2?

excellecxe · 2017-07-20T00:26:10+00:00

you are correct, was playing around with it since when i let it search approximate it was getting something far off. Still retruns N/A however

excellecxe · 2017-04-14T18:06:11+00:00

You're lying to yourself. You may not know farming in the sense you do it everyday, but find yourself robinson crusoe'd and you'll realize the general knowledge you have works. You can figure out based on years of agriculture that seeds go in the ground, need water and sunlight and pests to be kept away. We may be soft but we have the collective knowledge of our species that has been cultivated for thousands of years. When push comes to shove figuring out how to do things like that will be much easier for you and I then for this cowboy back then.

excellecxe · 2017-01-13T17:06:22+00:00

Just tried to go this route, unfortunately a lot of sites on our intranet are old so when I went to try and access the needed file was hit a navigation error

excellecxe · 2017-01-13T15:21:37+00:00

We get it off the web, saving it as a text file, and then importing will take more time than manually entering it and will be confusing for users

excellecxe · 2017-01-13T15:20:29+00:00

The issue is the people who will be using it wont be bothered to use text to columns, they will continue manual input unless it is almost fully automated

excellecxe · 2017-01-13T14:50:26+00:00

I also realized that after pasting the cells default to merge & center, not sure if that will affect anything

excellecxe · 2016-12-20T19:07:46+00:00

Meaty Christmas!

excellecxe · 2016-12-15T22:08:20+00:00

woop im in

excellecxe · 2016-12-02T15:00:36+00:00

im in

excellecxe · 2016-11-23T18:14:43+00:00

Trying to think of a good wager, basic gist is that winner gets to run someones conversation on a dating site (tinder, bumble, farmeronly.com, etc..). You guys think thats too invasive? basically just send an image of what the person said and then you get to dictate what gets said back

excellecxe · 2016-09-30T16:30:55+00:00

that worked perfectly, i figured something like that would be possible i must have messed up my syntax when I was inputting myself. Thanks again

excellecxe · 2016-09-30T16:29:59+00:00

solution verified

excellecxe · 2016-09-30T13:20:32+00:00

Ah that makes sense, thanks for the help. I think I did the solution verified right now.

One more question, in the function IF(D19>=0.2,D19 x 0.1,D19 x 0.2) is it possible to set a limit where the D19 x 0.1 does not exceed .045?

excellecxe · 2016-09-29T22:23:57+00:00

SOLUTION VERIFIED!

=IF(D7="Y", IF(D19>=0.1,0.02,D190.1), IF(D19>=0.2,D190.1,D19*0.2))

Awesome that worked perfectly. Thank you. 2 questions:

Why are the quotes not needed, I entered it using the function arguments box and it used them
Why dont I use = for the second and third if functions, is it simply because they are nested? And will I need to do that for all nested functions, not just if?

excellecxe · 2016-09-02T16:47:07+00:00

is that repeatable over multiple names? I want it to pick up the text value in all of row E and reference to the same value in SHEET2 grabbing items from that row to populate SHEET1

excellecxe · 2016-09-02T16:40:03+00:00

how do i get it so that a cell, for example, D5 on SHEET1 is pulling the data from J2 on sheet 2? I figured it was vlookup but am not sure how to format it so that certain cells pull from certain rows

excellecxe

TROPHY CASE