#1
|
|||
|
|||
I need a simple Formula :)
Hi,
Please I want a formula that when I write 1.04 in column (let's say A), it writes automatically 1.10 in column (B). And the same for the others, 1.07 in column A and 1.20 in column B. And the same for all rows till row 13. Please see the attachment |
#2
|
|||
|
|||
Is it a running number or based on the number in Column A?
It is always better to add an example worksheet so we dont have to waste time creatiing data that you already have If it is just a number then use =B1+0.1 |
#3
|
||||
|
||||
Does Col A always increase by .03 in the next row? Does Col B increase by .1 for every .03 increase in Col A?
|
#4
|
|||
|
|||
Here's a version of Purfleet's that "hides" the numbers until something (anything) is typed next to it in col A.
The formula is like =IF(A2="","",B1+0.1) Note that the top formula has the static "1.1" but the others add ".1" to the cell above it. What the formulas are doing is, "If the cell at my left is blank, return a blank. Otherwise, do this calculation." You can copy-n-paste from row two on down. Excel will auto-adjust the formulas. But just remember not to copy from row 1 down, because row one is different. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create a simple formula | ep2002 | Excel | 1 | 09-06-2017 11:00 PM |
Simple Excel Formula Help | BlueFunk3 | Excel | 2 | 06-08-2013 06:40 AM |
A simple select for a given math formula | Jo-NathanBSChE | Excel | 1 | 04-16-2013 03:10 AM |
Very simple formula needed! | nicholes | Excel | 4 | 04-12-2012 08:28 AM |
It has to be simple...formula | ClearSkies | Excel | 1 | 03-04-2011 01:06 PM |