Vikijadhav18
New Member
- Joined
- Jul 9, 2022
- Messages
- 12
- Office Version
- 2013
- Platform
- Windows
Following are the multiple if conditions that are needs to be combined in one formula. How can I do this.
=IF(AND(A6<=EOMONTH(I6,-1)+1,B6=""),DAY(EOMONTH(I6,0)))
=IF(AND(A6<=EOMONTH(I6,-1)+1,B6<=""),(B6-EOMONTH(I6,-1)))
=IF(AND(A6>=EOMONTH(I6,-1)+1,B6=""),(EOMONTH(I6,0)-A6)+1)
=IF(AND(A6<=EOMONTH(I6,-1)+1,B6=""),DAY(EOMONTH(I6,0)),(B6-A6)+1)
PLEASE HELP.
=IF(AND(A6<=EOMONTH(I6,-1)+1,B6=""),DAY(EOMONTH(I6,0)))
=IF(AND(A6<=EOMONTH(I6,-1)+1,B6<=""),(B6-EOMONTH(I6,-1)))
=IF(AND(A6>=EOMONTH(I6,-1)+1,B6=""),(EOMONTH(I6,0)-A6)+1)
=IF(AND(A6<=EOMONTH(I6,-1)+1,B6=""),DAY(EOMONTH(I6,0)),(B6-A6)+1)
PLEASE HELP.