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
|