'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
Hi All
Please help... I am trying to create a formula that captures a certain cell's value IF it is equal to or lower than 0 (zero). I am also trying to reverse this formula for another section. Can someone please provide a suggestion on this? I have been trying to figure this one out for the last four hours and am still having no luck. I am trying to use both IF and COUNTIF for these formlas. Is this correct or should I be using another sum? Cheers Paul |
'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
=IF(A1<=0,A1,"") see if this works -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=526568 |
All times are GMT +1. The time now is 08:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com