Thread: [Solved] Formulato say if cell is blank do this, if not blank do this.
View Single Post
 
Old 01-16-2015, 09:10 AM
mbesspiata mbesspiata is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default Formulato say if cell is blank do this, if not blank do this.
I have a pivot table that will vary from 4 to 5 columns when produced. It will place the data in from B5 to F5 if if 5 total columns are produced and from B5 to E5 if only the 4 total columns are produced. The last column is the total column in each scenerio.
I have another section where I take that data and and divide columns prior to the total column BY the total column to get a percentage.

A B C D E F
Count of Seizure NumberColumn Labels Row Labels1-3061-90>91Grand TotalCalifornia - West11Florida - Southeast22New Jersey - Northeast1135Texas - Central246Grand Total61714

What formula would I use for this?

Mike
Reply With Quote