Thread: Equation
View Single Post
  #2   Report Post  
olasa
 
Posts: n/a
Default


Yes it is. In your case:
A........B...........................C
10....=100-500+400.......=MMULT(MINVERSE(A1),B1)

The formula in C1 must be confirmed by holding down Ctrl and Shift, and
then hit Enter.

This will also work for larger equations (i.e. x,y,z)
If the formula don't find a solution, it will return #VALUE!


Hope it helped
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=379036