Windows 10: Anyone any good at spreadsheet formulas??

  1.    15 May 2017 #1

    Anyone any good at spreadsheet formulas??


    Hi Guys

    I am reasonably able to do formulas but one I need is foxing me, I will try to show example.

    Cell A Cell B Cell x (profit)
    100 150 50%

    I am displaying that A has made a 50% profit, but B will change from time to time so when B changes, I want X to show the new %. I believe it should be something like >>
    sum( B - A = 50 /100
      My ComputerSystem Spec

  2. jl2509's Avatar
    Posts : 100
    Windows 10 Pro
       15 May 2017 #2

    Ozgrid is a good place to start for Excel questions... HELP FORUMS
      My ComputerSystem Spec

  3. jl2509's Avatar
    Posts : 100
    Windows 10 Pro
       15 May 2017 #3

    FYI though assuming A1=100, B1=150 C1=(B1-A1)/A1
    format C1 as percent
      My ComputerSystem Spec

  4.    15 May 2017 #4

    jl

    Not working for me sorry, probably me though.

    If I quote say
    A is 5000
    B is 5203
    C is which hopefully will show as 4.06%

    So if I want C to change when I update B, what do yo say the formula should be ?

    Did I say it' Apache Open Office
      My ComputerSystem Spec

  5. jl2509's Avatar
    Posts : 100
    Windows 10 Pro
       15 May 2017 #5

    As above
      My ComputerSystem Spec

  6. jl2509's Avatar
    Posts : 100
    Windows 10 Pro
       15 May 2017 #6

    Click image for larger version. 

Name:	img.PNG 
Views:	20 
Size:	4.8 KB 
ID:	135140
    with your changed figures.
      My ComputerSystem Spec

  7.    15 May 2017 #7

    jl

    Again, I bow to your superior knowledge worked great, must make a note.

    Thanks again, clever people in Cheshire
      My ComputerSystem Spec

  8. jl2509's Avatar
    Posts : 100
    Windows 10 Pro
       15 May 2017 #8

    Good to know your fixed.

    Cheers
      My ComputerSystem Spec


 

Related Threads
I keep my checkbook on an Excel spreadsheet. I have a balance column that I use formulas =sum(A1:A6) etc to keep a running balance. Everything looks fine on the spreadsheet. But when I ask for a print preview those cells it show the formula...
Hello, I've been experiencing BSOD over the past month. Just ignored as it was random but i've now realised that it's usually happening when I'm using Excel. I have attached the dump files following the instructions on the forum. I've tried...
I've begun using snap in Windows 10 and like it for most purposes, but I very often use a spreadsheet in one window next to a browser window (typically Sheets w/in Chrome, but also stand-alone LibreCalc, with Chrome). (I am often gathering data on...
Apps & Features Create 3D Formulas in Excel in Tutorials
How to Create 3D Formulas in Excel 3D formulas are excellent ways of compiling data over multiple worksheets in Excel. 3D formulas work by effectively lining up worksheets one behind the other and adding through the same cell on each worksheet...
So Far, So Good in General Support
After installing Windows 10 onto my Dell 1545 it appears to run faster than Win-7 and while it will take some time to get used to MS Edge it appears to run faster as well. Learning curve is fair and not too steep. Happy so far. Hopefully I can...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 08:55.
Find Us