Data Validation Formulas.. Can if statements be used?

[450nick]

Hi all,

I'm trying to put a limit on the value of a number entered into a cell, based on another cell. If the driving cell is set to one value (list box) then the maximum number to be entered is 1.7, otherwise it is to be less than 3. Can this be written into the formula section? I've had a go using this:

=IF(H63="Trenching Vessel (Plough)", "<=1.7","<=3")

It currently flags up any value as being wrong though - how do I check its operation?

 

[450nick]

Don't worry, figured it out!

Here's what I used: =IF(H63="Trenching Vessel (Plough)", H65<=1.7,H65<=3)