Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Adding a "if blank" statement to an existing formula

Latest post Tue, Oct 18 2011 11:15 PM by Jim Cone. 1 replies.
  • Tue, Oct 18 2011 5:49 PM

    Adding a "if blank" statement to an existing formula

    I currently have a formula (Below) that checks tolerances and determains if the number passes a criteria where V$2 is 0 and W$2 is 4. I would like to add an "If Blank" return True/Blank(havent decided yet) statement but cannot find a place to put it where it will work.

     

    =IF(OR((AND(V7*0.95<=V$2,W7*0.95>V$2)),(AND(W7*0.95>=W$2,V7*0.95<W$2)),(AND(W7*0.95=V7*0.95,V7*0.95>=V$2,V7*0.95<=W$2,W7*0.95<=W$2)),(AND(V7<=V$2,W7>V$2)),(AND(W7>=W$2,V7<W$2)),(AND(W7=V7,V7>=V$2,V7<=W$2,W7<=W$2)),(AND(V7*1.05<=V$2,W7*1.05>V$2)),(AND(W7*1.05>=W$2,V7*1.05<W$2)),(AND(W7*1.05=V7*1.05,V7*1.05>=V$2,V7*1.05<=W$2,W7*1.05<=W$2))),TRUE,FALSE)

     

    Thanks for your time!

    • Post Points: 21
  • Tue, Oct 18 2011 11:15 PM In reply to

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 233
    • Points 3,320

    Re: Adding a "if blank" statement to an existing formula

    =IF(OR(ISBLANK(V2),ISBLANK(W2)),"BLANK",
    IF(OR(
    (AND(V7*0.95<=V$2,W7*0.95>V$2)),
    (AND(W7*0.95>=W$2,V7*0.95<W$2)),
    (AND(W7*0.95=V7*0.95,V7*0.95>=V$2,V7*0.95<=W$2,W7*0.95<=W$2)),
    (AND(V7<=V$2,W7>V$2)),
    (AND(W7>=W$2,V7<W$2)),
    (AND(W7=V7,V7>=V$2,V7<=W$2,W7<=W$2)),
    (AND(V7*1.05<=V$2,W7*1.05>V$2)),
    (AND(W7*1.05>=W$2,V7*1.05<W$2)),
    (AND(W7*1.05=V7*1.05,V7*1.05>=V$2,V7*1.05<=W$2,W7*1.05<=W$2))),TRUE,FALSE))
    '---
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (free and commercial excel programs)

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.