Spreadsheet help?

Need help making a website? Coding your own adoptables? Ask questions or share knowledge here

Spreadsheet help?

Postby Geowlett » Sat Aug 17, 2019 1:18 pm

Idk what I'm doing wrong here...

(Note: These are aj pet prices, not cs pet prices. Leaving this here so people know I'm not making this to trade between cs and aj)

Codes are:
Cost - =IF(A3=G2:G21, 2,3)
With Accessories - =SUM(A3,1)
Currently In Stores? - =IF(A3=G2:G21, "Yes","No")

I'm trying to make it so the cost for in-store pets costs 2 and out-of-store pets cost 3, with accessories is one extra. I'm trying to use the IF function to refer it to the "In Stores" table. And if the pet is in stores then it will say "Yes" under the Currently In Stores column.

Image
User avatar
Geowlett
 
Posts: 15636
Joined: Wed Dec 03, 2014 5:41 am
My pets
My items
My wishlist
My gallery
My scenes
My dressups
Trade with me

Re: Spreadsheet help?

Postby Geowlett » Sat Aug 17, 2019 1:32 pm

bump
User avatar
Geowlett
 
Posts: 15636
Joined: Wed Dec 03, 2014 5:41 am
My pets
My items
My wishlist
My gallery
My scenes
My dressups
Trade with me

Re: Spreadsheet help?

Postby Geowlett » Sat Aug 17, 2019 2:16 pm

bump
User avatar
Geowlett
 
Posts: 15636
Joined: Wed Dec 03, 2014 5:41 am
My pets
My items
My wishlist
My gallery
My scenes
My dressups
Trade with me

Re: Spreadsheet help?

Postby Geowlett » Sat Aug 17, 2019 4:12 pm

bump
User avatar
Geowlett
 
Posts: 15636
Joined: Wed Dec 03, 2014 5:41 am
My pets
My items
My wishlist
My gallery
My scenes
My dressups
Trade with me

Re: Spreadsheet help?

Postby Geowlett » Sun Aug 18, 2019 8:46 am

bump
User avatar
Geowlett
 
Posts: 15636
Joined: Wed Dec 03, 2014 5:41 am
My pets
My items
My wishlist
My gallery
My scenes
My dressups
Trade with me

Re: Spreadsheet help?

Postby Geowlett » Tue Aug 20, 2019 2:11 pm

bump
User avatar
Geowlett
 
Posts: 15636
Joined: Wed Dec 03, 2014 5:41 am
My pets
My items
My wishlist
My gallery
My scenes
My dressups
Trade with me

Re: Spreadsheet help?

Postby BayoDino » Wed Aug 21, 2019 7:18 pm

i don't get what do you mean actually . that uses which code and etc?











Image
BayoDino He/Her BisexualAbout X x Mascot OC
Pixel Pad!

Image











User avatar
BayoDino
 
Posts: 3935
Joined: Sat Jul 28, 2018 10:22 pm
My pets
My items
My wishlist
My gallery
My scenes
My dressups
Trade with me

Re: Spreadsheet help?

Postby ~Phantom » Wed Aug 21, 2019 8:54 pm

idk how to do it in excel, but i do in php.

you want a code that practically tells you the overall cost of a pet with accessories or without accessories, with the differentiating thing being if they are in or out of store?
┌───────────────┐

If you are talking with me currently,
please have patience as
I am struggling


└───────────────┘
.



┌──────┐



└──────┘
xxxxx
.
.
.
.
.
.
.
.
┌─────────────────────────┐




.
Image Image Imagex





└─────────────────────────┘
User avatar
~Phantom
 
Posts: 10094
Joined: Sun Feb 07, 2016 2:28 pm
My pets
My items
My wishlist
My gallery
My scenes
My dressups
Trade with me

Re: Spreadsheet help?

Postby Rolly-chan » Wed Aug 21, 2019 9:32 pm

Are you still looking for a solution?
If it's google spreadsheets you're talking about, you can try this:

Correct me if I'm wrong, but you don't have any data in column G, you only have filled columns A-D and F.
IF also cannot compare one value to several values, so you'll have to make a nested function here. Something like:
Code: Select all
IFERROR(IF(MATCH(A3,$F$3:$F$23,0),2,""),3)

The IFERROR is necessary in case MATCH doesn't find a match (it returns N/A if it can't find a match). Instead of N/A it will return 3. If it does find a match it will return 2.
The "$" are necessary so the referenced cells stay the same when you drag down the formula to the other cells in column A (and don't change to F4, F5 etc like the A cells do).

As for the With Accessories column, you use the pets column to add 1 to, which is a column with text values in the cells. You need to use the B column for that.

Analogous to the IF formula from the cost column, you can use:
Code: Select all
IFERROR(IF(MATCH(A3,$F$3:$F$23,0),"Yes",""),"No")

For the Currently in Stores? column.
User avatar
Rolly-chan
 
Posts: 2790
Joined: Tue Nov 18, 2008 8:09 am
My pets
My items
My wishlist
My gallery
My scenes
My dressups
Trade with me

Who is online

Users browsing this forum: No registered users and 1 guest