How I can merge/ combine all if conditions in one formula

[Vikijadhav18]

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.

 

[arthurbr]

B6<=""

What would this be ? all numbers are smaller than the null text string

 

[Vikijadhav18]

It stand for "if there is any value".

 

[arthurbr]

So it should be B6<>"" ?

 

[Vikijadhav18]

Thanks arthurbr. I made the change.

Can you help me on the merging the above conditions in one excel formula?

​

​