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
|