Spreadsheet help?

[MunchiiMoon]

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.

[MunchiiMoon]

bump

[MunchiiMoon]

bump

[MunchiiMoon]

bump

[MunchiiMoon]

bump

[MunchiiMoon]

bump

[--------------]

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

[~Phantom]

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?

[Rolly-chan]

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.