Nesting IF function

[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

 

[macropod]

Hi Martin,

=IF(A10<>1,"",IF(D6=CL,"",B10*G10))

Cheers

 

[Guest]

Hi
Try this:
=IF(A10<>1,"",IF(OR(D6="LH",D6="RH"),B10*G10,""))

Andy.

 

[Guest]

=IF(A1=1,IF(OR(D6="LH",D6="RH"),B10*G10,""),"")

 

[MartinW]

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?

 

[macropod]

Hmm,

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

Cheers

 

[MartinW]

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