Forum Discussion
Dazumi30
Aug 05, 2020Copper Contributor
Excel formula to populate a cell with Yes/No depending on dates on other cells.
Dear Team,
Pleas I need assistance in writing an excel formula to accomplish the following scenario.
For an equipment sign in/out sheet, I want a cell to be populated with either a "Yes " or "No" indicating availability status. The sheet would have multiple rows depending on how frequent the item is requested meaning the formula will always reference the last row in the table.
In the example attached, I want cell E4 to be populated with a "No" if the last cell of columns B and C are populated with dates and cell D is not (I.e equipment not returned). Otherwise, a "Yes" would be populated in Cell E4.
Thanks in anticipation.
Pleas I need assistance in writing an excel formula to accomplish the following scenario.
For an equipment sign in/out sheet, I want a cell to be populated with either a "Yes " or "No" indicating availability status. The sheet would have multiple rows depending on how frequent the item is requested meaning the formula will always reference the last row in the table.
In the example attached, I want cell E4 to be populated with a "No" if the last cell of columns B and C are populated with dates and cell D is not (I.e equipment not returned). Otherwise, a "Yes" would be populated in Cell E4.
Thanks in anticipation.
In E4:
=IF(AND(INDEX(C4:C1000,COUNT(B4:B1000))<>"",INDEX(D4:D1000,COUNT(B4:B1000))=""),"Yes","No")
If you expect to fill below row 1000, adjust the formula accordingly.
- GardeSourisCopper Contributor
Hello
I have attempted as formula for this, but I'm getting something wrong somewhere and I'd very much appreciate any assistance.
I basically want to write a formula, (or know if it is possible!) that populates a cell with an amount in a column, depending on the date in a cell
So, say, IF L11 is less than 10/01/2025, then equals S10, if not equals 0
But it would also be useful to have one to complete the task of if falls between two dates, then populate cell with amount.
The spreadsheet I am creating is for supplier payments due, for the current week and the following week or after this.
I think I will be able to write my own formula to pull out any direct debit designated ones, once I have seen the solution to this one, hopefully!
That is a very different problem, it would have been better to start a new discussion.
Please provide more detailed information. Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Dazumi30Copper Contributor
- ROB_N375Copper Contributor
CAN ANYONE TELL ME HOW I CAN GET A YES OR NO ANSWER ON WHETHER A DATE IS GREATER THAN 28 DAYS OR LESS THAN 28 DAYS I.E. BASED ON THE DATES IN ONE COLUMN ANOTHER COLUMN WOULD HAVE A FORMULA TO DISPLAY YES OR NO DEPENDING IF THAT DATE WAS 28 DAYS AGO OR LESS. HOPE THIS MAKES SENSE
- PoogermumBrass Contributor
please see file. Hope this helps. Done with if function and isblank function.