writing a formula
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 |
All times are GMT +1. The time now is 08:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com