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!

 

[Paulo H]

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

Brilliant that worked. How do I change the fill in the cell K and make it currency £ instead of just 0 cheers

 

[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!

Ignore last message sorted thank you for all your help

 

[Fluff]

Glad to help & thanks for the feedback.

 

[Paulo H]

Glad to help & thanks for the feedback.

Actually I have a question as how do I apply a formula to another part of dropdow menu eg in progress to read 0 too do i use elseif?

 

[Fluff]

How about

=IF(OR(O23={"unsuccessful","in progress"}),0,A23)