Value Minus Value = ???

Can't work this function out...

I want a box to minus another and give the total of whats left.

In the box i've put.. "=SUM(M2-F2)" and that just comes up and shows me "#VALUE!"

Whats do I need here?

Also, 1 last function that I can't figure out..

Is it possible in a value to do..

E.G.

=SUM(A1+.20p+3.4%)

I mean, box 1 + 20p + 3.4% = my total etc

Any idea's guys?

Many thanks

Emz

first formula....loose the SUM
=M2-F2

second

Do you mean I want the value of A1 add .20 (pence) and 3.4% of A1?

= A1 + 0.2 +(( A1 / 100)*3.4)

Drop the SUM() function:

=M2-F2

=A1+0.2p+.034

Some notes on the second function: I'm not sure exactly what "p" means or exactly what you want to do when you add 3.4%. Note that simply adding 3.4% as you did is equivalent to adding 0.034 like I did -- Excel doesn't assume to know what you mean when you add percentages like a hand calculator does. What most people want when they add a percentage like that is "take 3.4% of (A1+0.2p) and add that" which translates algebraically to (A1+0.2p)*0.034+(A1+0.2p) which simplifies to (A1+0.2p)*1.034

The % forumla don't work..

this is what I put in..

= D2 + 0.2 +(( D2 / 100)*3.4)

The value in D2 = 10.00 and the value in that box (that the above formula is in) brings me the total of £12.61 Thats not right

It should be £10.00 + 20p +3.4% =10.54

Any ideas?

Originally Posted by MrShorty

Some notes on the second function: I'm not sure exactly what "p" means or exactly what you want to do when you add 3.4%. Note that simply adding 3.4% as you did is equivalent to adding 0.034 like I did -- Excel doesn't assume to know what you mean when you add percentages like a hand calculator does. What most people want when they add a percentage like that is "take 3.4% of (A1+0.2p) and add that" which translates algebraically to (A1+0.2p)*0.034+(A1+0.2p) which simplifies to (A1+0.2p)*1.034

The p = Pence in £ (great british pound etc)

But I suppose that I don't need that? I just need 0.20 cus that is what it is...

Will try that now..

Originally Posted by MrShorty

=(A1+0.2p)*1.034

After loads of fiddling around, I've found out that the above sum works fine for me.

But now I need to change it slightlys.

(A1+0.2p)*1.034 = total then total minus A1 etc

So basically, it gives me A1 + 0.02 + 3.4% = Total

Then I want to minus A1 from that total so it gives me the fee's

(I'm working out money fee's on a spreadsheet etc)

Thanks guys, its much appreciated!!!

Anyone??

Does (A1+.2)*1.034-A1 work? [simplifies back to (A1+.2)*0.034]

Originally Posted by MrShorty

Does (A1+.2)*1.034-A1 work? [simplifies back to (A1+.2)*0.034]

Yes it does!!! Thank you so so so much! I've been tryna work out this for ages! Thank you!!!!! :D:D:D:D:D:D