Insert number into cell based on other cells containing x

Closed
gbroley Posts 1 Registration date Thursday 21 August 2014 Status Member Last seen 21 August 2014 - 21 Aug 2014 à 15:59
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 21 Aug 2014 à 18:14
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.

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
21 Aug 2014 à 18:14
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