Hi Group,

I'm having trouble nesting an IF function that I know is basic but I can't
get the right syntax.

D6 is a user input cell that will only contain either LH, RH or CL.

I need cell H10 to act as follows

If A10 doesn't equal 1 then return ""

If A10 equals 1 and D6 equals LH or RH then return B10*G10
but if D6 equals CL then return ""

Also will this work if I use data validation to make D6 a pull down list.

Thanks
Martin