I'm currently pulled data into a pivot table. I have an =if(or rule currently set up but the issue I am having is that there are less row cells for one of my filters. This is causing the rule I have set up to input verbiage into blank cells for my one filter. For instance, my rule states that if a cells value is over 100 "Not in Top 100" will appear for the cells down to row 76. For one filter there's only data for cells up to 49, but "Not in the Top 100" is still appearing.
How can I add an additional rule stating something like in a cell is blank ignore the rule and leave the cell blank?
Thanks for your help!
As long as you do not have any other conditions for the false part of the "Not in the Top 100", you can use this -=IF(AND(E8>100,E8<>""),"Not in top 100","")
Cheers,
Arlette
If I 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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks