Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-07-2019, 11:44 AM   #1
dcavaiani
Newly Registered User
 
Join Date: May 2014
Location: Appleton, WI
Posts: 266
Thanks: 172
Thanked 10 Times in 10 Posts
dcavaiani is on a distinguished road
Tryng algebra formula

How do I do this ??

(((O3-O2)*52) - ((P2-P3)*x) = 0)

dcavaiani is offline   Reply With Quote
Old 01-07-2019, 11:55 AM   #2
plog
AWF VIP
 
Join Date: May 2011
Posts: 9,322
Thanks: 10
Thanked 2,263 Times in 2,215 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Tryng algebra formula

Define "this". Classically that means solve for x. So, you need to get x on one side of equals sign by itself and then whatever is on the other side is the answer. Your function is equivalent to this:

A - Bx = 0

Where A and B are constants and x is the variable. First you get the x portion by itself by adding it to both sides (because its essentially negative now):

A = Bx

Then you divide both sides by whatever x is multiplied by:

A/B = x

That's your answer. Apply those 2 steps to your equation and you'll get it for yours.
plog is offline   Reply With Quote
The Following User Says Thank You to plog For This Useful Post:
dcavaiani (01-07-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula converted to access formula RobTuby Queries 9 12-01-2014 08:06 AM
Converting an excel formula into access query formula yaoi28lover Queries 15 04-23-2014 12:05 PM
Error 3163: The field is too small to accept the amount of data you're tryng to add Alc Queries 7 12-20-2013 11:02 AM
Question Expression Help? (Algebra is FUN!) carrybag93 General 7 05-24-2012 08:01 AM
Make array formula from non-adjacent cells to have other formula functionality inside maeda Excel 0 03-04-2009 06:07 AM




All times are GMT -8. The time now is 12:03 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World