Thread: Values not showing in worksheet

Hi!

I am working on a calculator at the moment and I have encountered a problem which I hope you guys may have a solution for. The problem is the formula below which has the first part of IF function is satisfied, however, for the second part the values are only returning as zero in the subsequent cells. When I checked with Insert Function of Formulas, the value required is calculated but at the same time, in the cell, it is still a zero! Can anybody help me on this? Thanks!

=IF(F39=$B$19,$B$20*((1+$B$18)^($B$19-$B$12)),IF((COUNTIF($I$4:I39,">0"))<($B$21+1),I38*(1+$B$18),0))

Hard to do much without knowing what's in the referenced cells. You could upload a sample file. Or, debug the formula piece by piece (edit the cell, highlight each term and hit <F9> to show the calculated values); as you go through, you will see if the whole thing truly evaluates to zero or where you're going wrong. If, at the end, what is shown doesn't mtch what it looked like when it was a formula, the problem is likely cell formatting.