Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |