Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Minus Display | Excel Discussion (Misc queries) | |||
strip minus signs from right to left | Excel Discussion (Misc queries) | |||
Calculate minus figures only | Excel Discussion (Misc queries) | |||
I want to get brackets round my figures not minus signs | Excel Discussion (Misc queries) | |||
minus formel/fortegn | Excel Discussion (Misc queries) |