Nesting IF function
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
|