How to stop excel from changing cell?

[iDare]

Hello guys, I would need some help - for you it probably is very easy, but I am still a beginner.

I am trying to make a list (watch the screenshot).

http://shrani.si/f/3P/Gx/4SuQezPf/shrani1.png

I would like to achieve that J column automaticly change ( to percentage ; 0% if conditions are not met ) after 3 condition -

condition 1 : column C has to be certain text
condition 2 : column G has to be certain text
condition 3 : H4 has to be over 4000€.

it works fine, BUT! it works fine until the H4 is not 4000€, once it reaches all position on the list get 2 or 3%.

What i want is that percentage in column J changes only when H4 is over 4000€ - i hope you get what i mean (its hard to explain), here is another screenshots what happens after H4>4000€

http://shrani.si/f/30/fc/1us7zj04/shrani2.png

in short: i dont want that J column changes before H4>4000€ and even when it reaches previous cells in J columnt mustn't change if the do not SUM more than 4000€


thank you very much in advance!

[ben_hensel]

I can't open the attached images, can you attach an example spreadsheet instead?

Anyway it sounds you want something like this:

Please Login or Register  to view this content.

[iDare]

Hi,

i've tried to upload them via another service:

http://postimg.org/image/hhw2dnedp/
http://postimg.org/image/4zhl5vxel/

i think you did not get what i want

[iDare]

I have my formula similar to yours, but the problem is when there are like 4 rows entered and the 5th row sums over 4000€ - then all row's J change, i want that only 5th J changes ( because H4 is over 4000€ )

[ben_hensel]

No, I didn't mean post the images to a different host, I meant post the spreadsheet itself.

Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.