-
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.
Can anyone break down this formula for me pls
- Thread starter shdwfx
- Start date
Breaking it down
if(d4<>5 is saying if the cell D4 is not equal to 5 to perform countif(o$3
3,">0")+1
countif(o$33,">0")+1 is saying to count all the cells in that range that have a value of greater than 0 (basically all positives and to add 1
As you drag down the column will expand because o$33 row is locked at the third row. Because of the +1 the cell returned will have a minimum of 1.
,"-") if D4 is equivalent to 5 to put a "-" in the cell
another way to write is which is doing the opposite due to change of operater sign
=IF(D4=5,"-",COUNTIF(O$3:O3,">0")+1)
if(d4<>5 is saying if the cell D4 is not equal to 5 to perform countif(o$3
3,">0")+1countif(o$3
3,">0")+1 is saying to count all the cells in that range that have a value of greater than 0 (basically all positives and to add 1As you drag down the column will expand because o$3
3 row is locked at the third row. Because of the +1 the cell returned will have a minimum of 1.,"-") if D4 is equivalent to 5 to put a "-" in the cell
another way to write is which is doing the opposite due to change of operater sign
=IF(D4=5,"-",COUNTIF(O$3:O3,">0")+1)
=if(d4<>5,countif(o$3
Last edited:
Upvote
0
Dave Patton
Well-known Member
- Joined
- Feb 15, 2002
- Messages
- 6,006
- Office Version
- 365
- 2010
- Platform
- Windows
You could step through the formula and/or try Excel's Formula Evaluate.
If D4 is less than or greater than 5
then Count O$3:O3 and add 1
otherwise i.e. D4 is equal to 5 entry the "-"
If D4 is less than or greater than 5
then Count O$3:O3 and add 1
otherwise i.e. D4 is equal to 5 entry the "-"
Upvote
0
