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

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

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555754

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

=IF(I60,I6,"")

Put that forumula in AB2

"changetires" wrote:


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

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555754

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

Lemme give it a try


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555754

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

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.

"changetires" wrote:


Lemme give it a try


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=555754