• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Clear #VALUE!. In complex formula (for me :-).

Must have hit the "post thread" B4 I was ready. :rolleyes:
In this worksheet I created a formula =IF(A6 >0, 2.375, "") in column D, G, I, L, to clear a number that I want to appear when I enter a value in the A & B column. That created a problem for columns P & Q however.
How do I incorporate a formula to clear or blank out the #VALUE! from the cells that are in error?

TobyB
 
I assume you use Excel 2003? Since you use .xls format.
You can next P & Q formula in IF statement like below.
=IF(A4="","",Your Formula)

You need something in A4 to do your calculation correct?
 
Chihiro, You are correct! I'm sure this is old hat for you. :) You make it look too easy, which I guess it is, if you understand how excel works. I think I learn something new every time I use it. Cool!
That worked like a champ.
Here is the formula: =IF(A4="","",IF(E4<>"",((A4-D4-(E4*F4)-G4)/(F4+1))+$N$2,(A4-D4-G4)+$N$2))

Thanks so much for helping me out today!
TobyB
 
You must log in or register to reply here.
Back
Top