Moving Cell Values

  • Thread starter Thread starter regdor
  • Start date Start date
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.
 
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.
 
Reformat your formulas into IF formulas, like.....

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

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex Lookup 3
formula for Excel 10
i need to seperate total time from billable time & non billable ti 7
Tracking billable hours 3
Insert date in formula 2
Time and Billing Database Setup Question 1
How to search for a value in a column in another Excel file 6
values v formulas with conditional formats 8

Back
Top