#Value Error

[hannakaram]

I create statement sheet, which have Debit (H), Credit (F) and Balance (G) Column.
Both Debit (H) and Credit (F) have Formulas to to calculate them Values.
In Balance I make this Formula, =IF(ISBLANK(C8),"",H7+F8-G8)
I use IF(ISBLANK just to keep the cell blank if there are no Data in that raw.
The problem is that I am getting #Value in Balance because either the (H) or the (F) Column have no Value.
How I can fix this??
Thanks

 

[Joe4]

I don't think it like setting numeric fields equal to "".
What if you try:

[COLOR=#333333]=IF(ISBLANK(C8),0,H7+F8-G8)[/COLOR]

If that does not work, please tell us the contents of C8, H7, F8 and G8.

 

[DanteAmor]

Both Debit (H) and Credit (F) have Formulas to to calculate them Values.

If the result of these formulas is "" (Blank), you should change it to 0 (zero), so you would not have problems.
But if you want to leave the result as "" (Blank), then try:

=IF(ISBLANK(C8),0,H7+IF(F8="",0,F8)-IF(G8="",0,G8))

 

[joeu2004]

=IF(ISBLANK(C8),"",H7+F8-G8)
[....]
The problem is that I am getting #Value in Balance because either the (H) or the (F) Column have no Value.

No. If H7 and F8 truly have "no value" (empty), they are interpreted as zero.

They might appear to be empty because their value (or G8) is the null string ("").

Moreover, your test ISBLANK(C8) might not always do what you intended if C8 might be the null string (""), not empty (no value).

To correct all of that, try:

=IF(C8="", "", SUM(H7,F8)-N(G8))

 

[DanteAmor]

Or also

=IF(C8="","",SUM(H7,F8,-N(G8)))

 

[hannakaram]

Or also

=IF(C8="","",SUM(H7,F8,-N(G8)))

Yesssss
This is the right one

Thanks a lot

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.