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.    15 May 2017 #2
    Join Date : May 2017
    Posts : 95
    Windows 10 Pro

    Ozgrid is a good place to start for Excel questions... HELP FORUMS
      My ComputerSystem Spec
  3.    15 May 2017 #3
    Join Date : May 2017
    Posts : 95
    Windows 10 Pro

    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.    15 May 2017 #5
    Join Date : May 2017
    Posts : 95
    Windows 10 Pro

    As above
      My ComputerSystem Spec
  6.    15 May 2017 #6
    Join Date : May 2017
    Posts : 95
    Windows 10 Pro

    Click image for larger version. 

Name:	img.PNG 
Views:	19 
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.    15 May 2017 #8
    Join Date : May 2017
    Posts : 95
    Windows 10 Pro

    Good to know your fixed.

    Cheers
      My ComputerSystem Spec

 


Similar Threads
Thread Forum
Solved Excel spreadsheet prints differently than what is on screen.
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...
Software and Apps
BSOD Usually happens when using Excel spreadsheet.
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...
BSOD Crashes and Debugging
Solved 2 panel snap w/ spreadsheet/browser: way to go back/forth w/o tab?
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...
General Support
Apps & Features Create 3D Formulas in Excel
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...
Tutorials
So Far, So Good
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...
General Support
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 00:54.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums