Formulla referenced a cell with a formula which renders as a blank

[robvasi]

I know it is hard to help me figure this out without seeing the spreadsheet.

Here is the formula that I can't get to work in each situation:

=IF(H88>0,H88,IF(H88="",IF(H22="Traditional",FV(H20/12,C46,(H31),-H45,1),FV(H20/12,C46,(0),-H45,1))))

H88 contains a formal that results in either a blank cell or a number.

Here is the formula for H88:

=IF(AND(H101,H114=""),"",H114-H101)

The formula works if H88 is a number, but it renders a blank if H88 is blank.

Here is what I want to happen:

If H88 is greater than zero (with means that the bank statement is recorded for that month), then put that value in the cell (H46 is the cell that contains this formula)

If H88 is blank (the formula renders a blank cell), then use the Future Value formula to render the value for the cell. If cell H22 contains words other than Traditional (the other word is ROTH), then use the FV formula with no payment (no withdrawal form the Traditional fund)

Where is the error?

I have struggled with this for many hours. A word of advice to all: do not struggle with an Excel formula prior to going to bed. My mind kept working on the formula and I work up with after a few hours of sleep.

[ConneXionLost]

Try testing for the blank first:

Please Login or Register  to view this content.

Cheers,

[JohnTopley]

try ...

=IF(AND(H101="",H114=""),"",H114-H101)

[robvasi]

Your solution solved the problem. The formula now works for all situations. Thank you!

[JohnTopley]

Glad it is solved.