|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.