Forum Discussion
Solved
Cell is equal to the most recent input
Does anyone know what formula I should be using?! I want a formula that can look at the status of all the invoices (2nd picture), and if they all say 'Paid,' then take the month of the most recen...
Hi YoloSpaceMuffin,
I hope I have interpreted your wish correctly. I'm afraid you haven't told us everything. Have a look at the enclosed example. I have created an IF() query that checks whether everything has been paid and, if so, gives you the maximum value for the date.
Does this come close to what you have in mind?
Hi YoloSpaceMuffin,
I hope I have interpreted your wish correctly. I'm afraid you haven't told us everything. Have a look at the enclosed example. I have created an IF() query that checks whether everything has been paid and, if so, gives you the maximum value for the date.
Does this come close to what you have in mind?
- What is the formula that you used?
- That is exactly what I'm looking for!
