Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2014, 01:48 PM
Dbjenkin Dbjenkin is offline Need a formula written for me Windows 8 Need a formula written for me Office 2007
Novice
Need a formula written for me
 
Join Date: May 2014
Posts: 1
Dbjenkin is on a distinguished road
Default Need a formula written for me


I am trying to set up an Ullage Chart for my job. I have a Template to use but instead of doing a Data input for 14 columns I want to set up a formula that will work for the whole chart. A partial example would be Column B (input a number in B1) and it subtracts from V1 and gives me the answer in C1. I need a formula that will work for inputting numbers in the following Columns B, E, H, K, N, Q, T Subtracting from Column V1 and it auto inputs into columns C, F, I, L, O, R, U.....

I will be inputting a total of 450 charts and really need to minimize the time spent data inputting into it.

I have a screenshot of the chart but I do not have permission to add attachment
Reply With Quote
  #2  
Old 05-13-2014, 05:46 AM
gebobs gebobs is offline Need a formula written for me Windows 7 64bit Need a formula written for me Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Isn't it as simple as

C1: V1-B1
F1: V1-E1
I1: V1-H1
L1: V1-K1
O1: V1-N1
R1: V1-Q1
U1: V1-T1

> I have a screenshot of the chart but I do not have permission to add attachment

That's going to rather handicap providing an answer. The screen capture would be nice though.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a formula written for me VBA to write into a Word doc from Outlook, then have Word VBA read what was written? stildawn Word VBA 1 09-29-2013 10:04 PM
Formula Help OTPM Excel 5 02-21-2013 08:03 AM
Blogs Written With Word Not Posting to Wordpress hpfan1972 Word 0 02-05-2013 04:48 PM
how can outlook "remember" a previous written email recepient? temuhin Outlook 2 04-29-2012 01:46 AM
Animation: text appears as if written by pen ionas.iona PowerPoint 0 03-31-2011 05:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:22 PM.


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