Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |