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,"")
 
Back
Top