#1
|
|||
|
|||
calculation if either of two fields is entered
I have two columns one with a design or measured flow rate in litre/hour and one in litres/sec. How do I set my sheet up so that if either value is entered it will calculate and enter the other?
ie l/hr l/s 75 0.021 |
#2
|
|||
|
|||
Hi BritBiker2
Can you post a sample of your worksheet so I can take a look for you. Tony |
#3
|
|||
|
|||
Thanks for your reply OTPM
Hopefully I have uploaded a copy of the sheet as you asked. The two columns concerned are those in red |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Thanks for your suggestion but I might be having a bad day as I am sorry to say it makes no sense to me.
|
#6
|
|||
|
|||
Hi
See attached workbook with it set up in columns O, P, Q and R. Change the figures in columns O and P and columns Q and R will recalculate. Hope this is what you are after. Tony |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calendar Entries Appearing without being entered | billp1955 | Outlook | 2 | 12-31-2012 12:40 PM |
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 |