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 |
Nesting IF function
Hi Martin,
=IF(A10<1,"",IF(D6=CL,"",B10*G10)) Cheers -- macropod [MVP - Microsoft Word] "MartinW" wrote in message ... 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 |
Nesting IF function
Hi
Try this: =IF(A10<1,"",IF(OR(D6="LH",D6="RH"),B10*G10,"")) Andy. "MartinW" wrote in message ... 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 |
Nesting IF function
=IF(A1=1,IF(OR(D6="LH",D6="RH"),B10*G10,""),"")
"MartinW" wrote: 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 |
Nesting IF function
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? |
Nesting IF function
Hmm,
Maybe we haven't understood your requirements. Perhaps you could restate them? Cheers -- macropod [MVP - Microsoft Word] "MartinW" wrote in message ... 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? |
Nesting IF function
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 |
All times are GMT +1. The time now is 11:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com