Value Minus Value = ???

E

Emzicle

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 m
"#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 :
 
D

Dnereb

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
 
M

MrShorty

Drop the SUM() function:

=M2-F2

=A1+0.2p+.034

Some notes on the second function: I'm not sure exactly what "p" mean
or exactly what you want to do when you add 3.4%. Note that simpl
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 percentage
like a hand calculator does. What most people want when they add
percentage like that is "take 3.4% of (A1+0.2p) and add that" whic
translates algebraically to (A1+0.2p)*0.034+(A1+0.2p) which simplifie
to (A1+0.2p)*1.03
 
E

Emzicle

MrShorty said:
=(A1+0.2p)*1.034
Click to expand...

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

Emzicle

MrShorty said:
Does (A1+.2)*1.034-A1 work? [simplifies back to (A1+.2)*0.034]
Click to expand...


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