Good Afternoon I am trying to combine 2 formulas:
1. =IF(C10="Current",(65.5*DAY(EOMONTH(G1,0))))
2. =IF(C10="Move Out",(DAY(D10-G1)*65.5))
Into one cell. With trial and error I get a "FALSE" answer when using the foillowing:
=IF(C10="Current",(65.5*DAY(EOMONTH(G1,0))=IF(C10="Move...