| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF/OR Logic Function
I cannot figure out how to nest a logic funtion.
I have =IF(M8="1st Monday",I8,"") I would like to nest =IF(K14="15th",I14,"") in the same cell. Thanks for the help Jason |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF/OR Logic Function
try (untested)
=IF(M8="1st Monday",I8,IF(K14="15th",I14,"") ) -- Don Guillett Microsoft MVP Excel SalesAid Software "Jason" wrote in message ... I cannot figure out how to nest a logic funtion. I have =IF(M8="1st Monday",I8,"") I would like to nest =IF(K14="15th",I14,"") in the same cell. Thanks for the help Jason |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF/OR Logic Function
Do you want the first IF to take precedence over the second IF? You could try:
=IF(M8="1st Monday",I8,IF(K14="15th",I14,"")) Or do you want both cells to display if both are true? Then try: =IF(M8="1st Monday",I8,"") & IF(K14="15th",I14,"") If neither of these are what you're looking for, then perhaps provide more info on what you want and maybe include some sample data. HTH Elkar "Jason" wrote: I cannot figure out how to nest a logic funtion. I have =IF(M8="1st Monday",I8,"") I would like to nest =IF(K14="15th",I14,"") in the same cell. Thanks for the help Jason |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF/OR Logic Function
I am setting up a budget. I need two types of data to insert into the same
cell. The two questions are when does a paycheck post. The first option is "1st Monday" of the month: =IF(M9="1st Monday",I9,"") The second option is the "5th" being a date: =IF(K14="5th",I14,"") So I need to be able to populate the same cell if both formulas are true with the sum of both entries. And also to populate the cell if one is false and another true and vice versa. Thanks Jason "Elkar" wrote: Do you want the first IF to take precedence over the second IF? You could try: =IF(M8="1st Monday",I8,IF(K14="15th",I14,"")) Or do you want both cells to display if both are true? Then try: =IF(M8="1st Monday",I8,"") & IF(K14="15th",I14,"") If neither of these are what you're looking for, then perhaps provide more info on what you want and maybe include some sample data. HTH Elkar "Jason" wrote: I cannot figure out how to nest a logic funtion. I have =IF(M8="1st Monday",I8,"") I would like to nest =IF(K14="15th",I14,"") in the same cell. Thanks for the help Jason |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF/OR Logic Function
Ok, see if this works:
=IF(AND(M9="1st Monday",K14="5th"),I9+I14,IF(M9="1st Monday",I9,IF(K14="5th",I14,""))) HTH Elkar "Jason" wrote: I am setting up a budget. I need two types of data to insert into the same cell. The two questions are when does a paycheck post. The first option is "1st Monday" of the month: =IF(M9="1st Monday",I9,"") The second option is the "5th" being a date: =IF(K14="5th",I14,"") So I need to be able to populate the same cell if both formulas are true with the sum of both entries. And also to populate the cell if one is false and another true and vice versa. Thanks Jason "Elkar" wrote: Do you want the first IF to take precedence over the second IF? You could try: =IF(M8="1st Monday",I8,IF(K14="15th",I14,"")) Or do you want both cells to display if both are true? Then try: =IF(M8="1st Monday",I8,"") & IF(K14="15th",I14,"") If neither of these are what you're looking for, then perhaps provide more info on what you want and maybe include some sample data. HTH Elkar "Jason" wrote: I cannot figure out how to nest a logic funtion. I have =IF(M8="1st Monday",I8,"") I would like to nest =IF(K14="15th",I14,"") in the same cell. Thanks for the help Jason |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF/OR Logic Function
=IF(M8="1st Monday",I8,"")
=IF(K14="15th",I14,"") Which of those should have precedence? Take your pick: =IF(M8="1st Monday",I8,IF(K14="15th",I14,"")) =IF(K14="15th",I14,IF(M8="1st Monday",I8,"")) -- Biff Microsoft Excel MVP "Jason" wrote in message ... I cannot figure out how to nest a logic funtion. I have =IF(M8="1st Monday",I8,"") I would like to nest =IF(K14="15th",I14,"") in the same cell. Thanks for the help Jason |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF/OR Logic Function
does one or the other have to take precedence or can they be equal
"T. Valko" wrote: =IF(M8="1st Monday",I8,"") =IF(K14="15th",I14,"") Which of those should have precedence? Take your pick: =IF(M8="1st Monday",I8,IF(K14="15th",I14,"")) =IF(K14="15th",I14,IF(M8="1st Monday",I8,"")) -- Biff Microsoft Excel MVP "Jason" wrote in message ... I cannot figure out how to nest a logic funtion. I have =IF(M8="1st Monday",I8,"") I would like to nest =IF(K14="15th",I14,"") in the same cell. Thanks for the help Jason |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF/OR Logic Function
Ok, after reading your follow-up to Elkar, this will do what you want:
=(M9="1st Monday")*I9+(K14="5th")*I14 -- Biff Microsoft Excel MVP "Jason" wrote in message ... does one or the other have to take precedence or can they be equal "T. Valko" wrote: =IF(M8="1st Monday",I8,"") =IF(K14="15th",I14,"") Which of those should have precedence? Take your pick: =IF(M8="1st Monday",I8,IF(K14="15th",I14,"")) =IF(K14="15th",I14,IF(M8="1st Monday",I8,"")) -- Biff Microsoft Excel MVP "Jason" wrote in message ... I cannot figure out how to nest a logic funtion. I have =IF(M8="1st Monday",I8,"") I would like to nest =IF(K14="15th",I14,"") in the same cell. Thanks for the help Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logic function for between | Excel Discussion (Misc queries) | |||
| Wording's Colour Change for Logic Function | Excel Discussion (Misc queries) | |||
| Logic Function Help… | Excel Discussion (Misc queries) | |||
| Wording's Colour Change for Logic Function | Excel Discussion (Misc queries) | |||
| Excel Logic Function | Excel Discussion (Misc queries) | |||
Hybrid Mode
