 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2007Ohm's Law
I need to create a little sheet to calculate different aspects of Ohm's Law and I need some help to create formulas, please: B C D E F 5 6 7 8 9 Now, if I enter any value in E5 and F5, I need B6 to give me the result of F5/E5*E5 calculation. This would be simple for me to do, but there is more to it: What if I enter values into D5 and F5 and calculation now is D5*D5/F5? Then, next formula is: D5/E5. All results in the same cell B6. In other words, I need the results of different formulas in one cell B6 depending which values I enter. Then later I'll need results of different formulas in cells: B7,B8,B9 based on the same principle as the first example. I hope it's pretty clear, Can somebody help me, please. Once I get the formula I think I'll understand it, just don't know how to start. Thanks in advance Mark Maybe something along the lines of =IF(AND(D5<>"",F5<>""),D5*D5/F5,IF(AND(D5<>"",F5<>""),D5*D5/F5,IF(AND(D5<>"",E5<>""),D5/E5,"")))  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I need to create a little sheet to calculate different aspects of > Ohm's Law and I need some help to create formulas, please: [quoted text clipped - 26 lines] > > Mark >Maybe something along the lines of > >=IF(AND(D5<>"",F5<>""),D5*D5/F5,IF(AND(D5<>"",F5<>""),D5*D5/F5,IF(AND(D5<>"",E5<>""),D5/E5,""))) Thank you Bob, it works but I have one more problem and a question. I'll start with question: what does it mean: D5<>"" I understand that <> means number different then zero, but "" (?) Now the problem: How do I enter this formula in that chain: in cell B7, C4*E4/Square root of F4*C4 The key was IF(AND( I knew I had to use IF but then I got stuck... Thanks again Mark ACtually D5<>"" means this: It returns TRUE if the text is D5 is <> (Greater Than or Less Than) ""(Empty string). On Feb 16, 1:30 pm, mar...@hotmail.com wrote: > >Maybe something along the lines of > [quoted text clipped - 15 lines] > > Mark Weird way of saying, if D5 is NOT blank Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) ACtually D5<>"" means this: It returns TRUE if the text is D5 is <> (Greater Than or Less Than) ""(Empty string). On Feb 16, 1:30 pm, mar...@hotmail.com wrote: > On Fri, 16 Feb 2007 17:35:26 -0000, "Bob Phillips" <bob....@xxxx.com> > wrote: [quoted text clipped - 18 lines] > > Mark =C4*E4/(F4*C4)^0.5 >>Maybe something along the lines of >> [quoted text clipped - 15 lines] > > Mark Should that be C6 etc? Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >>Maybe something along the lines of >> [quoted text clipped - 15 lines] > > Mark I put this together quickly, it doesn't check to make sure that you have numbers, it assumes that you are going to put numbers in the cells. For your example that you gave you would put: =ohmslaw(D5,E5,F5) in cell B6 If you don't have enough numbers then it returns -1. Public Function OhmsLaw(r1 As Range, r2 As Range, r3 As Range) As Double If Not r1.Value = "" And Not r2.Value = "" Then OhmsLaw = r1.Value / r2.Value ElseIf Not r1.Value = "" And Not r3.Value = "" Then OhmsLaw = r1.Value * r1.Value / r3.Value ElseIf Not r2.Value = "" And Not r3.Value = "" Then ' assuming you mean f5/(e5^2) OhmsLaw = r3.Value / (r2.Value * r2.Value) Else OhmsLaw = -1 End If End Function Cheers, Jason Lepack On Feb 16, 12:22 pm, mar...@hotmail.com wrote: > I need to create a little sheet to calculate different aspects of > Ohm's Law and I need some help to create formulas, please: [quoted text clipped - 26 lines] > > Mark >I put this together quickly, it doesn't check to make sure that you >have numbers, it assumes that you are going to put numbers in the [quoted text clipped - 52 lines] >> >> Mark Thank you all for your help Mark |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.