Greeting all, If possible i need a little help with a formula in Excel, if someone can kindly offer some advice?

I require Excel to provide a 4th value of the missing field; If i know 3 of the other values.

V1=voltage in

V2=voltage out

R1=Resistor 1

R2= Resistor 2formulas are:

V2=V1xR2/R1+R2

V1=V2(R1+R2)/R2

R1=R2(V1-V2)/V2

R2=R1xV2/V1-V2Any help would be very much appreciated, as I'm not sure if MS Excel is possible of doing such.

Thanks kindly and wish you where ever you are a special day

Adon

This appears to be a homework assignment

and as such we won't give you the answer,

but if you post the formulas you have tried,

we can point you in the right direction.MIKE

message edited by mmcconaghy

Are you sure you have your equations correct? V2=V1xR2/R1+R2 is very different from V2=V1xR2/(R1+R2)

R2=R1xV2/V1-V2 is very different from R2=R1xV2/(V1-V2)

Are you sure that you aren't missing some parentheses?

Here's a hint on how to set up the Excel formulas:

Start with this set up in a spreadsheet:

A B C 1 Term Value Result 2 V1 3 V2 4 R1 5 R2Since you know what mathematical relationship exists between the 4 variables, enter equations in Column C referencing the corresponding cells in Column B. In other words, wherever you have V1 in an equation, substitute B2 in your Excel formula.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

DerbyDad03 makes an important point. Maybe your formulae were written like this:

V1xR2

--------

R1+R2If so the top line is divided by the sum of R1 and R2, in other words when writing it

on one lineit should be V1xR2/(R1+R2)

Alwayspop back and let us know the outcome - thanks

message edited by Derek

thanks all for the replies, it's appreciated! and sorry for the equations error, as i typed them in as fast as possible without checking the post first before submitting. What i am trying to achieve is to try and find the correct values for an electronic circuit, if i already know three of the values and have Excel display the 4th correct value.

It is not for an assignment, just for a quick way for me to get the values to design circuits.

so, say if i know the output voltage (V2) and both the resistors (R1 & R2) values i would like to use in the circuit, by typing into excel their values it would give me the input voltage (V1) value to power the circuit.

Sorry to say but i am a little vague with Excel and wondered whether it could do this as such.

I have found this website calculator at: http://www.daycounter.com/Calculato...

but is not able to do what I'm after. So i thought i could some how use the formulas i have provided (in their correct form - Thanks for pointing this out) and using Excels "cells" put it together in a small simple quick little package for myself.

Thanks for your responses and hopefully with your smart minds i can have a solution.

I already gave you the steps required to write your formulas in response #2. Do you know enough about Excel to write a formula? If not, I can give you some more details.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History