Moving Cell Values

R

regdor

How can I get excel to separate cell values based on some form of conditional
statement? Such that entering a code such as 9999 in one cell will cause the
value of another cell to shift into a different column. I am trying to
distinguish between billable and non billable time.
 
G

Gary''s Student

Just use an extra cell (cells are cheap). Say if A1 is 9999 we want 13 to
appear in column C, otherwise 13 should appear in column D.

1. put 13 in B1
2. put =IF(A1=9999,B1,"") in C1
3. put =IF(A1=9999,"",B1) in D1

The 13 will move depending on whether you put 9999 in A1 or some other walue
in A1.
 
C

CLR

Reformat your formulas into IF formulas, like.....

=IF(A1=9999,YourFormula,"")
or
=IF(A1=9999,"",YourFormula)

Vaya con Dios,
Chuck, CABGx3
 
Top