equations

Hello, I am attempting to speed up the process by which we calculate weight percent of sulphuric acid based off specific gravity and temperature. The issue I am having is, the values given in the charts we have are not exact, therefore we have a hand-written equation that is tried-and-true...

Hello, This is my first post so bare with me. I am extremely new to VBA. I am creating a database using excel. I am trying to write a code for an equation that will use numbers inputted to my spreadsheet via a userform. The equation should take three values, say A, B, and C. Run them through the...

The Equation is quite simple and i might be an idiot for missing something or it may not be possible. I basically have a row counter, simple equation "=$A2+1" , just dragged down so it works in the appropriate cell. The problem is when a row is deleted the numbers are changed to "=#REF!+1" is...

I don't know if this is the correct term, but I hope you guys understand. Please bear with me as I'm a newbie when it comes to this. I am having a hard time to reflect one equation to another equation. I am not sure but this might need dimming. Requesting for backup :nya: Sub test232() Dim...

Good Afternoon, I am trying to find a way to do conditional functions based upon multiple criteria and I can't seem to find a way to do this. What I have: Multiple columns of information: ID, Day of Week, Week of, Start Date/Time, End Date/Time What I would like: I'd like to subtract the...

Hi all I am trying to find out whether it is capable in MS Excel to write an algorithm or some sort of VBA code whereby excel will fill in the "blanks" of a formula to give pre-determined results. Let me try to explain myself more clearly. Say for example I had 2 equations. Equation #1: (a +...

Right, what I'm attempting to do here is work out the cost incurred to each individual of a number of people who went on a trip. Basically, I paid for everything and now want to split the cost between appropriate people so I made a table (food down the side and people along the top). The...

OK this question might be a little complicated and confusing but I'll do my best... Basically I have a spreadsheet of soccer goals. This includes the time each goal was scored, the resulting differential in the game from the goal, and the result of the game. I want to use this data to find...

How can I develop a macro that solves a system of equations using Crammer's Rule or another feasible rule. I will like the macro to be able to handle as many as 6 equations. One (very hypothetical) example just to show what I am talking about. 10x + 5y + 2z = 10 15x + 2y + 20z = 30 Need...

I have a spreadsheet (Excel 2007) that uses vba to create a Word 2007 document. Quite a few things flow from Excel to Word, including data and tables. Pushing info in that direction works fine. However, I would like to insert equations into the Word document similar to Word's Equation Editor...