Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-29-2013, 09:00 AM
OTPM OTPM is offline calculation if either of two fields is entered Windows 7 32bit calculation if either of two fields is entered Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Here is one suggestion:
A B C D
Input Output
l/h l/s l/h l/s
60 0.520 1872 0.017

In columns A and B you have your free text input i.e. you enter the figures.
In column C and D you have your calculations for l/h and l/s.
When you change any entry in columns A or B your output columns are then automatically recalculated.
You could also lock columns C and D so no one can change them by accident.
Hope this helps.
Good luck.
Tony
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
calculation if either of two fields is entered Calendar Entries Appearing without being entered billp1955 Outlook 2 12-31-2012 12:40 PM
calculation if either of two fields is entered Can entered text automatically appear in 2 different locations? wordwrkr Word 1 12-22-2012 12:17 PM
Please help with age calculation!!! Microsoft Idiot Word 4 10-29-2012 05:54 AM
Print handouts with notes I entered kennydude PowerPoint 2 10-16-2012 05:24 AM
how to make fields calculation variable according to the filter i use duraid Project 0 09-09-2010 01:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:08 PM.


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