| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignoring Cells through IF Functions
In cell A1 i have 200, in cell A2 I have 250
In cell A3 I have an if function =if(a1<0,A1,"")&if(A2<0,A2,"") My question is, can I make a formula to say that if A2 is 0 then it would ignore cell A1... So if A2 is blank, then my output would be blank??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ignoring Cells through IF Functions
should work:
=IF(A2="","",IF(A1<0,A1,"") & IF(A2<0,A2,"")) "Hamed parhizkar" wrote: In cell A1 i have 200, in cell A2 I have 250 In cell A3 I have an if function =if(a1<0,A1,"")&if(A2<0,A2,"") My question is, can I make a formula to say that if A2 is 0 then it would ignore cell A1... So if A2 is blank, then my output would be blank??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum ignoring cells with error | Excel Worksheet Functions | |||
| Ignoring blank cells | Excel Discussion (Misc queries) | |||
| Statistical Functions ignoring errors | Excel Discussion (Misc queries) | |||
| Ignoring Formulas within cells | Excel Worksheet Functions | |||
| Ignoring cells with no value | Excel Programming | |||
Hybrid Mode
