Formula linking........Help!!!!!!!!!!!!!!!

  • Thread starter Thread starter changetires
  • Start date Start date
C

changetires

Cell AB2 displays a positive number but in a red cell which indicates
negative number.
Cell I6 is going to use this cell in its formula but only if it is
red number not a green one. Green will indicate also a postive numbe
but in this case green number cell will not be used in the formula.
Can anyone help with this?

E
 
You also need to consider how that value will or will not be used in a
formula somewhere. If for addition or subtraction, probably want it to be
set to zero when not to be used, but if it is for multiplication or division,
then may need to set it to 1 (so as to not get a divide by zero error).

Or your end formula can use an IF( statement to decide which of two formulas
to use based on the value. Like:
=IF(AB2<0, A1 * A2, A1 * A2 + AB2)
so if value in AB2 is less than zero, the cell will show the result of A1 *
A2 (or whatever other calculation you need) which doesn't use AB2 at all, but
if AB2 => 0 then the second formula will be used.
 
Back
Top