1. G

    Inverse Percentage

    Hi All, I'm trying to show the inverse percentage of a number, and I am struggling to figure out how to do it. Can you please give a it a look and let me know if you can help me. So basically what I'm trying to achieve is if its comes up as 99% I would like it to show as 1%. Here is the Macro...
  2. J

    Values from a weighted average

    Hi all, I am new to the forum so hopefully this is posted in the correct place. I am trying to three derive values from a weighted average that I know. The below data starts in A1. I know the weighted average value of my data is 473.27, I need a formula to calculate the three missing values in...
  3. M

    Making an 18x18 Matrix

    Hello! I have to make an 18x18 matrix calculator using excel for my math project. It should be able to solve the determinant, the inverse, the answers if there were a given system of equations, and the L&U of the matrix. I know I could easily do those by using the built-in matrix functions, but...
  4. B

    Flipping a cell content in Excel 2007

    Hello How can I flip the content of a cell in Excel 2007 For example:- I want to have Trim Motors : Electrical System : Honda Outboard as Honda Outboard : Electrical System : Trim Motors I have thousands of cells with data in this order that I need to reverse/ flip. Please advise Thanks a lot
  5. L

    Reverse Poisson?

    Not sure if anyone can help with this. Basically I'm trying to find out how to apply the reverse of the Poisson function in excel. So as of now I have poisson(x value, mean, true-cumulative) and that lets me get the probability for that occurence. Basically I want to know how I can get the...

Some videos you may like

This Week's Hot Topics