Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete numbers in a cell
I have two rows, one with numbers A, and one empty B. I put "x" in B, when I
need to show that the payments in A has been done. How do I make the numbers dissapear? I have formatted A so that the numbers in A gets white when I write "x" in B so the numbers don't show. But the numbers are still there(althoug hidden), and the sum in the bottom don't change. Is there a formel I can use? Great if you know! -- Therese |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete numbers in a cell
Instead of putting values in A like 123.45, put a formula like:
=IF(B1="x","",123.45) When you change the B's the A's will really vanish. -- Gary's Student "Therese" wrote: I have two rows, one with numbers A, and one empty B. I put "x" in B, when I need to show that the payments in A has been done. How do I make the numbers dissapear? I have formatted A so that the numbers in A gets white when I write "x" in B so the numbers don't show. But the numbers are still there(althoug hidden), and the sum in the bottom don't change. Is there a formel I can use? Great if you know! -- Therese |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete numbers in a cell
Suppose your numbers are in column A, and you enter x in column B, then use
a formula something like this: =SUMIF(B1:B4,"<x",A1:A4) This will sum only those cells that do not have an adjoinin x in it. Mangesh "Therese" wrote in message ... I have two rows, one with numbers A, and one empty B. I put "x" in B, when I need to show that the payments in A has been done. How do I make the numbers dissapear? I have formatted A so that the numbers in A gets white when I write "x" in B so the numbers don't show. But the numbers are still there(althoug hidden), and the sum in the bottom don't change. Is there a formel I can use? Great if you know! -- Therese |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
How can I add different numbers in a same cell? | Excel Discussion (Misc queries) | |||
how to count occurence of numbers separated by , in a single cell | Excel Worksheet Functions | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |