Thanks to the 3 individuals responding to my question last week concerning moving the date forward to the first of the month.
I have two additional issues:
1) Why does this formula not work:
=if(A="N/A" & B<>"N/A","ERROR","OK")
2) I have linked several sheets in one spreadsheet. When I sort the primary sheet, the linked sheets will adjust correctly, but the cell references within the primary sheet do not --- which causes major problems.
This is a result of one such formula: =IF(K7=52,MRP52!E2,MRP12!E2)
It should read =IF(K2=52,MRP52!E2,MRP12!E2)
The issue is the reference to cell K2, it changes to K7. Any idea ??
Thanks Art Mueller
I have two additional issues:
1) Why does this formula not work:
=if(A="N/A" & B<>"N/A","ERROR","OK")
2) I have linked several sheets in one spreadsheet. When I sort the primary sheet, the linked sheets will adjust correctly, but the cell references within the primary sheet do not --- which causes major problems.
This is a result of one such formula: =IF(K7=52,MRP52!E2,MRP12!E2)
It should read =IF(K2=52,MRP52!E2,MRP12!E2)
The issue is the reference to cell K2, it changes to K7. Any idea ??
Thanks Art Mueller