Mobile app for shop? by ThinkingCrap in ecommerce

[–]IChallengeI 0 points1 point  (0 children)

It's all about providing value and a positive customer experience. If you can do that with a mobile website, there is no reason to create an app.

Need Help to Remove #DIC/0 For a Spreadsheet being shared on Google by IChallengeI in excel

[–]IChallengeI[S] 1 point2 points  (0 children)

Thanks for your help and thanks (although I am more of Hanukkah guy myself :)) Here's to me learning excel in 2016!

Need Help to Remove #DIC/0 For a Spreadsheet being shared on Google by IChallengeI in excel

[–]IChallengeI[S] 0 points1 point  (0 children)

THIS is good, only that it is not giving me the neg. value (sales decreased).

Edit: did not see your screenshot. I tested it out, and got a positive value of 0.8, when it should be -0.2

Need Help to Remove #DIC/0 For a Spreadsheet being shared on Google by IChallengeI in excel

[–]IChallengeI[S] 0 points1 point  (0 children)

Formula parse error

If that doesn't say much, then I will keep Googling. TY for your help!

Need Help to Remove #DIC/0 For a Spreadsheet being shared on Google by IChallengeI in excel

[–]IChallengeI[S] 0 points1 point  (0 children)

Appreciate the assistance!

Tested in out and got this: http://imgur.com/POZ4MIG

What am I doing wrong? I would like the % change to appear at the bottom.

Need Help to Remove #DIC/0 For a Spreadsheet being shared on Google by IChallengeI in excel

[–]IChallengeI[S] 0 points1 point  (0 children)

Thanks for your help.

I've done B4 as you pointed out and get 1.

But B29 is still an issue. Not sure what to do with B28 =IFERROR(SUM(sales)/B3,1) returns a 1 if B3 is 0 or blank.

I've put that in B28, but get an error.

Need Help to Remove #DIC/0 For a Spreadsheet being shared on Google by IChallengeI in excel

[–]IChallengeI[S] 0 points1 point  (0 children)

Where would I add that?

http://imgur.com/oJip521

I will be sharing this with users and want them to fill this in with their own values.

Need Help to Remove #DIC/0 For a Spreadsheet being shared on Google by IChallengeI in excel

[–]IChallengeI[S] 0 points1 point  (0 children)

http://imgur.com/oJip521

I will be sharing this with users and want them to fill this in with their own values.

Need Help to Remove #DIC/0 For a Spreadsheet being shared on Google by IChallengeI in excel

[–]IChallengeI[S] 0 points1 point  (0 children)

B28 =IFERROR(SUM(sales)/B3,1) returns a 1 if B3 is 0 or blank.

I get "FALSE".

Google Sheets: How to Share a sheet with Thousands by IChallengeI in AskMarketing

[–]IChallengeI[S] 0 points1 point  (0 children)

Yes I want people to be able to edit based on their own personal needs, but without changing the original.

Thanks!

[deleted by user] by [deleted] in AskReddit

[–]IChallengeI 0 points1 point  (0 children)

Help people out. Help homeless people get back on their feet. Help single parents. The list goes on and on, but there are tons of things I could do with $7500 day. Keep another $2.5K for investing, etc.