solve

I just need a very simple explanation. On this worksheet, I'm only presented with graphs and I have to come up with the two equation by myself. How would you solve for the equation?

Hi guys, Ive spent the last 2 hours trying to solve this problem and I've hit a wall. Any help would be much appreciated!! I have this number in a cell 00:20:00 i'd like to remove the last three characters :00 iv'e tried using left and right but it doesn't work and outputs some random number...

Hi guys, Ive spent the last 2 hours trying to solve this problem and I've hit a wall. I have this number in a cell 00:20:00 i'd like to remove the last three characters :00 iv'e tried using left and right but it doesn't work and outputs some random number and not 00:20 after striping the last...

Hi! I have a sheet filled with 9-digit figures (ex. 172234512) There is a need to sort out every figure with the status of the 5:th digit. What is the most easy way to solve that? For example: if the 5:th digit is 3 (like above) then mark the cell red. If the 5:th digit is 2 (172224512) mark it...

Hello, I am wondering if it is possible in VBA to load one Solver model (saved in a range) execute it then load another model (saved in another range) replace the first one and execute and so on. Example: SolverLoad loadArea:=Range("A1:A8") then solve, move on to SolverLoad...

I have some math problem written in others cell and i want its answer to appear in other cell Example: in cell A2 i have 2*3*(5+4) and i want its answer to be appeared in B2

Hi! How can I in an equation with two variable solve for x using letters in Excel? E.g. I have the following problem: y = -2*x+150 Find expression for x. I know the answer is x = -0.5*y + 75 but can Excel find that out for me? I'm new in here so I really hope you can help me. Best, Mads.

Hi there, I have a probably quite simple problem but I am still trying to get to grips with using Solver in VBA and I am struggling to get this formula to work. Basically I have a table with 5 Columns and 6 rows and I want to make it so that the numbers in the 3rd column are such that the...

Hello everyone, i've stumbled with this small puzzle: you have to arrange the numbers from 1 to 9 to make this horizontally and vertically correct: ---- + ---- + ---- = 15 ---- + ---- + ---- = 16 ---- + ---- + ---- = 14 = = = 16 15 14 i've already...

A1=.2 A2=.3 A3=.5 A4=sum(A1:A3)=1.0 I'd like to make a calculation to put in A1 (at least I think its this cell), that would allow me to change A2, leave A3 constant at .5, and A4 sum would always be equal to 1.0. For example in the next scenario. A2=.4, A3=.5, and A4, the sum would still...

Hello all, I need to create an excel spreadsheet that can solve a system of linear equations by only entering the a, b, c, d, e, and f of: ax + by = c dx + ey = f I am a rookie at excel and algebra. So when explaining on how to do this please treat me as such. I need to know exactly what...

Hi, I have detailed my simple calculation below. A balance is derived from Cost, Deposit and Part Ex and then the repayment is calculated based on a balance, interest rate and loan term. I have no experience whatsoever of macros but believe that it is possible to insert command buttons next to...

Dear all, I have a question about solving a formula in Excel. An equation is based on the following: [a]x^2 + [b]x + c = 0 The value for a, b and c are known. Is it possible to, and if so how, let Excel solve the value for x???

So what it's the big mystery then... I've created an excel file with links to diffrent other files. And now when I've shared the workbook and other users are supposed to input comments in their respective sheet, some of them just disappears! Anybody who have any clue of what that's all about...