Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2021, 11:46 PM
emvella emvella is offline I need a simple Formula :) Windows XP I need a simple Formula :) Office 2007
Novice
I need a simple Formula :)
 
Join Date: Sep 2009
Posts: 11
emvella is on a distinguished road
Default 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
Attached Images
File Type: png Excel.PNG (5.4 KB, 21 views)
Reply With Quote
  #2  
Old 06-14-2021, 02:27 AM
Purfleet Purfleet is offline I need a simple Formula :) Windows 10 I need a simple Formula :) Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Attached Files
File Type: xlsx I need a simple Formula_ar12.xlsx (9.0 KB, 10 views)
Reply With Quote
  #3  
Old 06-15-2021, 04:41 AM
Marcia's Avatar
Marcia Marcia is offline I need a simple Formula :) Windows 10 I need a simple Formula :) Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Does Col A always increase by .03 in the next row? Does Col B increase by .1 for every .03 increase in Col A?
Reply With Quote
  #4  
Old 06-17-2021, 09:20 AM
Steve Kunkel Steve Kunkel is offline I need a simple Formula :) Windows 10 I need a simple Formula :) Office 2019
Advanced Beginner
 
Join Date: May 2019
Location: Seattle area
Posts: 77
Steve Kunkel is on a distinguished road
Default

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.
Attached Files
File Type: xlsx I need a simple Formula_ar12-R.xlsx (9.5 KB, 5 views)
Reply With Quote
Reply

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
I need a simple Formula :) Simple Excel Formula Help BlueFunk3 Excel 2 06-08-2013 06:40 AM
I need a simple Formula :) 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
I need a simple Formula :) It has to be simple...formula ClearSkies Excel 1 03-04-2011 01:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:25 AM.


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