Data validation IF statement

**christopherp** · 11-12-2009, 10:59 AM

Hi There

I am trying to create a data validation rule that only allows a neagtive value to be entered if the word "backcharge" appears in an adjacent cell.

So far I have come up with = if(d2="backcharge",<=0, .... But I am not sure how to finish it off.

I am sure this is relatively simple problem but any help is greatly appreciated.

Cheers

Chris

**NBVC** · 11-12-2009, 11:05 AM

Try custom Data Validation formula, assuming you are entering number in E2:

=AND(D2="Backcharge",E2<0)

**christopherp** · 11-12-2009, 11:09 AM

wow thanks for the quick reply... that worked a treat but....

**christopherp** · 11-12-2009, 11:18 AM

wow thanks for the quick reply... that worked a treat but....

the way the spreadsheet is setup the value is entered before backcharge can be selected from the dropdown list

I.E the value is entred in column D and the drop down list is in column F so in practice the value will be entered first.

The rule works just fine when the drop down box is used to select backcharge and then the value is entered but not the other way round

Any suggestions?