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 :)


--
Emzicle
------------------------------------------------------------------------
Emzicle's Profile: http://www.excelforum.com/member.php...o&userid=26552
View this thread: http://www.excelforum.com/showthread...hreadid=398163

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)


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=398163

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


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=398163

Dnereb Wrote:
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)

Thanks and yes to the above!

So thats all I need? will try that now... :)


--
Emzicle
------------------------------------------------------------------------
Emzicle's Profile: http://www.excelforum.com/member.php...o&userid=26552
View this thread: http://www.excelforum.com/showthread...hreadid=398163

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? :)


--
Emzicle
------------------------------------------------------------------------
Emzicle's Profile: http://www.excelforum.com/member.php...o&userid=26552
View this thread: http://www.excelforum.com/showthread...hreadid=398163

MrShorty Wrote:

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


--
Emzicle
------------------------------------------------------------------------
Emzicle's Profile: http://www.excelforum.com/member.php...o&userid=26552
View this thread: http://www.excelforum.com/showthread...hreadid=398163

MrShorty Wrote:
=(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!!! :)


--
Emzicle
------------------------------------------------------------------------
Emzicle's Profile: http://www.excelforum.com/member.php...o&userid=26552
View this thread: http://www.excelforum.com/showthread...hreadid=398163

Anyone?? :(


--
Emzicle
------------------------------------------------------------------------
Emzicle's Profile: http://www.excelforum.com/member.php...o&userid=26552
View this thread: http://www.excelforum.com/showthread...hreadid=398163

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


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=398163

MrShorty Wrote:
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


--
Emzicle
------------------------------------------------------------------------
Emzicle's Profile: http://www.excelforum.com/member.php...o&userid=26552
View this thread: http://www.excelforum.com/showthread...hreadid=398163