# What is the suitable formula if getting error: #VALUE!

1. ## What is the suitable formula if getting error: #VALUE!

I want to make an excel formula which shows empty cell if H2+G3-F3=0
and show the calculated answer if H2+G3-F3>0.
The Formula will be applied to cell H3. I tried =if(H2+G3-F3=0,"",H2+G3-F3) and =IF(H2+G3-F3<=0,"",H2+G3-F3) but then H3 gives #Value!.

Thanks for the help but Non of the following formulas are working for me. I have uploaded the sheet.

2. ## Re: Suitable Formula

Use this one's

and

3. ## Re: Suitable Formula

the suitable formula
=IF(H2+G3-F3=0,"",H2+G3-F3)

4. ## Re: Suitable Formula

hi umais,

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.
so please do change the title. it is easier for others to search when they have similar problems. for this case, you can try:
=IF(SUM(H2,G3)-F3=0,"",SUM(H2,G3)-F3)

5. ## Re: What is the suitable formula if getting error: #VALUE!

Thank you all for the help. The formula that worked for me is =IF(SUM(H2,G3)-F3=0,"",SUM(H2,G3)-F3).

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1