Share via

Ohm's Law Calcularor

Anonymous
2016-12-07T22:28:19+00:00

I need to build a calculator with 4 possible inputs where any 2 of the inputs is used to calculate the others. Just like the Ohms law where you have 4 variables of Voltage, Current, Resistance and Power. Any of the 2 can be used to calculate the others. Writing out the formulas shows there are 3 different ways to calculate each factor. How do I make a calculator using the combinations shown in the picture?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2016-12-11T21:29:45+00:00

Replace  section  #1 in the macro with this one.

     '#1

    If volt And Amp <> "" Then

        Range("C6") = volt * Amp

        sqrA = Amp * Amp

        Range("C5") = Range("C6") / sqrA

If your question is answered, would you mark the post Anwered.

Was this answer helpful?

0 comments

15 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-12-08T14:31:37+00:00

    Time to code a simple UDF function and store it in Personal?

    cheers

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-12-08T14:16:04+00:00

    HI Bernard

    I'm still using XL 2003

    I'm an old dinosaur on the way to extinction. LOL

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-12-08T13:53:20+00:00

    Use =FORMULATEXT( ) to display formulas then any worksheet restructuring will be compensated fro

    best wishes

    Was this answer helpful?

    0 comments
  4. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2016-12-08T13:51:49+00:00

    How do I make a calculator using the combinations shown in the picture?

    If you want to have only 4 cells and calculate the other 3 cells if you change the value of a cell, you must write a VBA code to accomplish this. Have a look into this file:

    https://dl.dropboxusercontent.com/u/35239054/Pythagoras.xlsm

    Otherwise follow the instruction provided by Cimjet.

    Andreas.

    Was this answer helpful?

    0 comments