Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
This will return the value in A1 if it is less than 0. You did not say what
to do if the cell is greater than 0, so this will return a blank (ie "") =IF(A1<=0, A1, "") "PaulH-Oz" wrote: 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 |
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 |