multiple functions in one formula

Originally Posted by shg

Any of these:

=A2 - 0.75*G2 - (A2 - 0.75*K2)

= 0.75*K2 - 0.75*G2

=0.75*(K2 - G2)

I used the top formula but I re wrote it a little becuase I noticed that I would need a range of cells in the second function. The formula now looks like:
=B23 - 0.75*G23 - (B23 -0.75*K23:M23)

The problem is all I get is a #value error.

Thanks,

Erik

Here is how I changed the formula so that it worked but I want to use a range so I can add aadditional colums and have the caluculations auto adjust.

=B2-0.75*G2-(B2-0.75*(K2+L2+M2))

As you can see in the second function I am subtracting the sum of cells K2 to M2 multiplied by .75 from the contents of cell B2. I attempted to write the formula like this =B2-0.75*G2-(B2-0.75*(K2:M2))
but recieved the same error.

Erik