I have a tracker I'm using for a work project and have several parameters I need to fill in data for. For tracking, I'm using a simple if statement to show if there is data populated, return a "yes". If not, return "no". ex: =IF('PS(Opt,FI,Eq)'!B2="TBD","NO","YES"). I have a similar formula for B2-N2that references a different tab on my sheet. I want to show if all cells have a "Yes", return a "Yes" to show all items are completed. I'm trying to use this formula but get an error. Can someone see what I'm doing wrong?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks