# Thread: #Value Error Thanks:  2 Post #5359975 (1)Post #5359548 (1) Likes:  2 Post #5359548 (1)Post #5359975 (1)

1. ## #Value Error

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  Reply With Quote

2. ## Re: #Value Error

I don't think it like setting numeric fields equal to "".
What if you try:
Code:
`=IF(ISBLANK(C8),0,H7+F8-G8)`
If that does not work, please tell us the contents of C8, H7, F8 and G8.  Reply With Quote

3. ## Re: #Value Error

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))  Reply With Quote

4. ## Re: #Value Error Originally Posted by hannakaram =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))  Reply With Quote

5. ## Re: #Value Error

Or also

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

6. ## Re: #Value Error Originally Posted by DanteAmor Or also

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

Yesssss
This is the right one

Thanks a lot  Reply With Quote

7. ## Re: #Value Error  Reply With Quote

## User Tag List

balance, danteamor, igold, my aswer is this, pcl 