Link data validation drop down to alter a value in another cell

[Paulo H]

Hi

I have created a dropdown box via data validation which works well
I am trying to work out if ther is away of linking a value to this that be will alter a cell

eg A column contains the value of “potential”orders which I mark as pending. However if the deal doesn’t come off I mark it as “unsuccessful”

what i wish to do is link this as a zero value to the cell on that row that is in the value column which thus will take it off the sum total of that column

ie cell “M23” has value of£100 when marked as “potential” but makes it zero when marked as “unsuccessful’

feel I should not how to do this!

 

[Fluff]

Do you mean M23 shows the value of A23 unless you change the drop down to unsuccessful?

 

[Paulo H]

Yes if dropdown was insuccessful then M23 = 0. Guess A23 would need to be made 0 too?

 

[Fluff]

You would not be able to change col A if it's a value. What column is the drop down in?

 

[Paulo H]

The drop down is in column O

 

[Fluff]

Ok, how about

=IF(O23="unsuccessful",0,A23)

 

[Paulo H]

Hi

I will give that a go and let you know

thanks

 

[Paulo H]

Ok, how about

=IF(O23="unsuccessful",0,A23)

 

[Paulo H]

hI
Above shows what I am trying to achieve when the dropdown changes to Not successful the amount in value Column M changes to £0.00

 

[Fluff]

From those images it looks like you mean the value in col K not M, so just put the formula in col K