Insert number into cell based on other cells containing x

Closed
gbroley Posts 1 Registration date Thursday August 21, 2014 Status Member Last seen August 21, 2014 - Aug 21, 2014 at 03:59 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 21, 2014 at 06:14 PM
I am setting up a spreadsheet tracker for the school. I want J2 to auto fill a price depending on whether C2-G2 have an X. BUT, depending on which cell has the X will depend on which price to put in. C2 and D2 are one price, E2 and F2 are one price, and G2 is a third price.
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 21, 2014 at 06:14 PM
gbroley, Good evening.

I believe there are a lot of ways to do this one.

As you did not mentioned how you obtain the right price for each position I did an example for you.

Take a look at it.
http://speedy.sh/nmRGy/21-08-2014-enKioskea-Value-Based-on-Position-OK.xlsx

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0