Excluding a Cell range from a selection in a drop down list

[Jasmaine86]

Hi All,

I currently have a budget sheet where when i select a customer from a drop down list, the ratio will calculate and change the result to show the overall profit as per selected customer.

The client was created by a data validation list and the ratio through a xlookup.

The ratio in coulmn B is a simple =F$3 and adjusts when you change the customer in the drop down.

Everything works as it should however, i need to exclude ROW9, Column B from the selection when i choose two particular customer as the value is not relevant - Example Client WHC needs to be 0%.

basicually, is there a IF formula to exclude CELL 9B or calculate to be 0% when customer WHC and X are selcted from the drop down list?

 

[Georgiboy]

How about making the formula in column B:

=IF(OR($E$3="WHC",$E$3="X"),0,$F$3)

 

[Jasmaine86]

How about making the formula in column B:

=IF(OR($E$3="WHC",$E$3="X"),0,$F$3)

Thank you so much! it worked a treat. I new it was a simple formula but i could not get myself there.

 

[Georgiboy]

You ate welcome, thanks for the feedback.