Thread
:
writing a formula
View Single Post
#
2
Posted to microsoft.public.excel.misc
Gary L Brown
Posts: n/a
writing a formula
=(1-F6)/(F6+Z6+IF(AA6<0,0,AA61))
HTH,
--
Gary Brown
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
"changetires" wrote:
How do I write this logic as a formula. 1-F6/F6+Z6+AA6
Cell F6 could be a 0.......and I dont want Cell AA6 in the calculation
if the cell turns red not a font red but fill red. Cell will turn red
when the number is negative but will not display a negative number just
the red cell with the number in it in black
tks
--
changetires
------------------------------------------------------------------------
changetires's Profile:
http://www.excelforum.com/member.php...o&userid=35414
View this thread:
http://www.excelforum.com/showthread...hreadid=556048
Reply With Quote