directing a total to various cells dependent of its value

  • Thread starter Thread starter Debi
  • Start date Start date
D

Debi

If i have a cell value through using a series of formula's, how can i direct
this value to two seperate cells (one if the value is negative and one if its
positive) which can then be used on another worksheet.

Thanks
 
Cant you have two formulas as below

Cell 1
=IF(currentformula>=0,currentformula,"")

Cell 2
=IF(currentformula<0,currentformula,"")
 

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

Formula in a cell depending on the value of another cell 1
Question about conditional formatting of zeros in Excel 0
Set chart series endpoint dynamically 0
format cells depending on value range 5
directing the sum of a cell to either of two cells depending on va 3
calculate formula if cell value is positive, show 0 if negative 3
conditionally formatting colour of cells 2
Reallocate array cells value from positive to negative 0

Back
Top