B
Bernie R.
I have a workbook with several worksheets that is fed data from Access (via a
worksheet in the workbook called "rawdata".
I have a formula (shown below) that worked when the worksheet didn't import
the Access data, but doesn't work after the Access import. After the import,
F7=2 and only EZ7 and FA7 has data (all data are dates). The blank cells
show "=rawdata cell#" when clicked on. I've tried changing "sum" to count,
counta, but the cell continues to show "GO". Is there a way to correct this
formula in excel so the cell will show "NO GO" if the criteria isn't met?
=IF(AND(F7=1,SUM(EW7,EZ7,FA7,FD7)>=3),"GO",IF(AND(F7=2,SUM(EW7,EZ7,FA7,FC7,FD7)>=4),"GO",IF(AND(F7=3,(SUM(EZ7,FA7,FD7,GA7,GB7,GC7)>=5)),"GO","NO GO")))
I hope I explained this where it makes sense.
Appreciate anyones help on this.
worksheet in the workbook called "rawdata".
I have a formula (shown below) that worked when the worksheet didn't import
the Access data, but doesn't work after the Access import. After the import,
F7=2 and only EZ7 and FA7 has data (all data are dates). The blank cells
show "=rawdata cell#" when clicked on. I've tried changing "sum" to count,
counta, but the cell continues to show "GO". Is there a way to correct this
formula in excel so the cell will show "NO GO" if the criteria isn't met?
=IF(AND(F7=1,SUM(EW7,EZ7,FA7,FD7)>=3),"GO",IF(AND(F7=2,SUM(EW7,EZ7,FA7,FC7,FD7)>=4),"GO",IF(AND(F7=3,(SUM(EZ7,FA7,FD7,GA7,GB7,GC7)>=5)),"GO","NO GO")))
I hope I explained this where it makes sense.
Appreciate anyones help on this.