Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spacebar creates value error
A3 is the sum total of A1 plus A2
If I clear either A1 or A2 with the spacebar I get a value error. I know I can "clear the contents" or enter zero but is there another way around this because using the spacebar is better for us. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spacebar creates value error
=IF(ISNUMBER(A1+A2),A1+A2,"")
Try that "Dennis1188" wrote: A3 is the sum total of A1 plus A2 If I clear either A1 or A2 with the spacebar I get a value error. I know I can "clear the contents" or enter zero but is there another way around this because using the spacebar is better for us. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spacebar creates value error
=sum(a1:a2)
But I've never seen using the spacebar work better than clearing the cell (using the delete key on the keyboard). I find that writing formulas like this a real pain. =if(a1=" ", ... and if the user hit the spacebar twice (or more) =if(a1=" ",... And to add =trim() around every reference can be a pain, too: =if(trim(a1)="",.... Dennis1188 wrote: A3 is the sum total of A1 plus A2 If I clear either A1 or A2 with the spacebar I get a value error. I know I can "clear the contents" or enter zero but is there another way around this because using the spacebar is better for us. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spacebar creates value error
How does the spacebar 'clear' anything?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dennis1188" wrote in message ... A3 is the sum total of A1 plus A2 If I clear either A1 or A2 with the spacebar I get a value error. I know I can "clear the contents" or enter zero but is there another way around this because using the spacebar is better for us. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spacebar creates value error
You are definitely not doing this the right way, since you don't know which
cells are truly empty or just blank. BUT ... you might try the SUM() function, which ignores your keystroke: =Sum(A1:A2) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Dennis1188" wrote in message ... A3 is the sum total of A1 plus A2 If I clear either A1 or A2 with the spacebar I get a value error. I know I can "clear the contents" or enter zero but is there another way around this because using the spacebar is better for us. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spacebar creates value error
Click in a populated cell and hit <space, then <enter.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bernard Liengme" wrote in message ... How does the spacebar 'clear' anything? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dennis1188" wrote in message ... A3 is the sum total of A1 plus A2 If I clear either A1 or A2 with the spacebar I get a value error. I know I can "clear the contents" or enter zero but is there another way around this because using the spacebar is better for us. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP post UDF (#DigitsFirstID) creates error | Excel Worksheet Functions | |||
Spacebar to tab | Excel Discussion (Misc queries) | |||
=DATEVALUE("7/1/20"&MID(C3,13,2)) creates error | Excel Worksheet Functions | |||
Opening excel creates an error message or opens Book 1 | Setting up and Configuration of Excel | |||
Combobox creates error | Excel Worksheet Functions |