Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula help
I want to return an "X" in column Y if column 0 has the number 21 thru 27 all
other values return nothing. column o is currently a caculated field with the formula: =SUM(TODAY()-P5) column O is for number of days and invoice is past due column P currently has a date field. I want to be able to identify accounts once a week that hit the 21-27 day past due days so that I can write a letter to these customers. What formula would be best to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula help
Put this in Y5:
=IF(O5<21,"",IF(O5<28,"X","")) Copy down as required. Hope this helps. Pete On Aug 12, 4:59*pm, Belinda7237 wrote: I want to return an "X" in column Y if column 0 has the number 21 thru 27 all other values return nothing. column o is currently a caculated field with the formula: =SUM(TODAY()-P5) column O is for number of days and invoice is past due column P currently has a date field. I want to be able to identify accounts once a week that hit the 21-27 day past due days so that I can write a letter to these customers. What formula would be best to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|