View Single Post
  #1   Report Post  
Emzicle
 
Posts: n/a
Default 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 :)


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