Nesting IF function

  • Thread starter Thread starter MartinW
  • Start date Start date
M

MartinW

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
 
I can't make sense of this. All three of those formulae look like they
should work but I can't get any of them to function, I just end up
with a blank cell. Any thoughts on what I might be doing wrong?
 
Hmm,

Maybe we haven't understood your requirements. Perhaps you could restate
them?

Cheers
 
Found the problem. Feel pretty stupid. Earlier when I was formatting I
merged C6 and D6, column C is very very narrow but nevertheless it
is the true destination of my target cell.

Thanks to All
Martin
 
Back
Top