| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return 0 if result of formula is lower than 0.5
=IF(your_formula<=.5,0,your_formula)
-- Gary''s Student gsnu200712 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return 0 if result of formula is lower than 0.5
Thanks! I knew i was thinking to difficult.
Another question where you might can help me out. =IF(SUMPRODUCT(ISNUMBER(SEARCH("break",$C$2:$R$2)) *(C3:R3=0.25)),SUMPRODUCT(ISERR(SEARCH("evt",$C$2: $R$2))*(ISERR(SEARCH("ABS",$C$2:$R$2)))*(ISERR(SEA RCH("lunch",$C$2:$R$2)))*C3:R3),0) The formula looks for EVT / ABS / Lunch in the header row and does not include the value's under those headings in the total result. Instead of not including these, i would like the formula to substract them from the total. "Gary''s Student" wrote: =IF(your_formula<=.5,0,your_formula) -- Gary''s Student gsnu200712 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My formulas return the formula not a result in the cell | Excel Worksheet Functions | |||
| Creating a formula to return a particular result from a Matrix Tab | Excel Discussion (Misc queries) | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Formula should return a result but doesn't | Excel Worksheet Functions | |||
| Choose between two cells the lower result of a formula | Excel Worksheet Functions | |||
Hybrid Mode
