Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Formulato say if cell is blank do this, if not blank do this. Formulato say if cell is blank do this, if not blank do this.
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-16-2015, 09:10 AM
mbesspiata mbesspiata is offline Formulato say if cell is blank do this, if not blank do this. Windows 7 64bit Formulato say if cell is blank do this, if not blank do this. Office 2010 64bit
Advanced Beginner
Formulato say if cell is blank do this, if not blank do this. 		 
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
  #2  
Old 01-17-2015, 05:02 AM
gebobs gebobs is offline Formulato say if cell is blank do this, if not blank do this. Windows 7 64bit Formulato say if cell is blank do this, if not blank do this. Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Attach the sheet please.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulato say if cell is blank do this, if not blank do this. Place 0 in blank cell mbesspiata Excel 5 06-20-2014 07:00 PM
Formulato say if cell is blank do this, if not blank do this. not showing blank cell alw Excel 4 03-13-2014 01:08 PM
won't show blank cell bhum Excel 2 01-28-2014 02:34 AM
Page numberring 1 - blank - 2 - blank etc Intern PowerPoint 0 09-02-2011 01:16 AM
Formulato say if cell is blank do this, if not blank do this. How to turn all blank lines into non-blank for legal forms sieler Word 3 04-12-2009 01:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft