-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
return blank
-
D
Why won't this return a BLANK cell?
I have a formula that adds up information between 6 worksheets. If there is no information greater than ZERO in either cell I want it to be BLANK but it returns 0 =IF(OR(F3>0, O3>0,F3-((IF(SUM('Week 42:Week 52'!P3)>0,SUM('Week 42:Week 52'!P3))))), " ") Cell F3 is just a standard number, cell...- dragonmouse
- Thread
- 42week blank cell formula return blank
- Replies: 5
- Forum: Excel Questions
-
A
Multiple If, or, and
Greetings all - I would like very much to get some assistance with the following please, if anyone has thoughts on it. =IF(BB2="","",IF(AND($AR2="x",$AZ2="L",$AV2="C",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="O",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="B",J3>...- aiki100
- Thread
- formula multiple arguments multiple if and or return return blank
- Replies: 8
- Forum: Excel Questions
-
P
Aggregate Function showing #DIV/0!
Dear All, I use an aggregate function to determine the average of the non-error values in a list, once the list is populated it works perfectly, however while the list is empty it returns "#DIV/0!". In such instances I want the formula to return a blank, however, as much as I try I can't get a...- Poenankie
- Thread
- aggregate return blank
- Replies: 2
- Forum: Excel Questions
