Automatically populated according to time intervals

Hello,

I need some help with my worksheet excel:

untitled.JPG


Basically what I want is:

When I insert a value in "OCC" column, I need the columns of StopSales be automatically populated (either a cross or something else).

Only those columns must be filled according to time intervals:

0-130 - all in white
131-190 - Cl MS
191-220 - Cl MS + C River
221-254 - Cl MS + C River + Tw MS
255-263 - Cl MS + C River + Tw MS + Tw River

For example, if the "OCC" is 192, must appear filled the columns "Cl MS + C River".

Someone can help me? Sending attached excel document.

Thank you so much!

I'm attaching the file for you so that the formula will be translated into your language, but you can use this formula in H3:

=IF($F3<=130,"",IF(MATCH($F3,{131,191,221,255})>=COLUMNS($H:H),"*",""))

then copy across and down as required.

Hope this helps.

Pete

Thanks Pete, you really rocks!

Without abusing you and since you understood exactly what I wanted, did you could help me with this:

In the column "Price", how do I get that change automatically depending on the columns of StopSales?

For example:

If I have a cross in the "Cl MS" column, I want the value to be 140. But if I have a cross in column "Cl MS + C River", I want to be 160.

No Cross: 125
Cl MS: 140
Cl MS + C River: 145
Cl MS + C River + Tw MS: 160
Cl MS + C River + Tw MS + TW River: 210

THANKS AGAIN!!!

Is this the kind of thing that you mean? I've put the following formula in G3:

=IF(F3<=130,125,CHOOSE(COUNTIF(H3:K3,"~*"),140,145,160,210))

and then copied down.

Hope this helps.

Pete

P.S. If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Thank you so much Pete

You're welcome - thanks for feeding back.

Pete