Formula not working
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. |
All times are GMT +1. The time now is 12:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com