+ Reply to Thread
Results 1 to 3 of 3

if statement with isblank and if greater than

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    Margate, FL
    MS-Off Ver
    MS Office 2016
    Posts
    222

    if statement with isblank and if greater than

    How do I add an ISBLANK to this formula?

    =IF(A$1>A2,(A1-A2),0)

    So this formula is to calculate this:

    If my cell in A1 is larger than the one below, then A1 minus A2, if not 0... but what if there is nothing on A2.. I would like it to come back blank.

    a1 = $2000 amount to be paid
    a2 = $1000 amount paid
    a3 = blank

    b2 = is the difference (will be $1000)
    b3 = should be BLANK
    Last edited by trosasco23; 04-13-2021 at 03:18 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,631

    Re: if statement with isblank and if greater than

    =if(isblank(a2),"",max(a1-a2,0))
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    06-27-2014
    Location
    Margate, FL
    MS-Off Ver
    MS Office 2016
    Posts
    222

    Re: if statement with isblank and if greater than

    Thank you Ben.. It didn't work as I needed it to but thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] isblank with If statement
    By ConfusionSetsIn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2016, 07:11 PM
  2. [SOLVED] if statement, isblank, then
    By KClem in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-24-2016, 07:06 AM
  3. [SOLVED] Nested if(isblank) statement
    By Groovicles in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-13-2013, 09:50 AM
  4. Using OR and ISBLANK in an IF Statement
    By amwbogan1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-24-2013, 09:43 AM
  5. [SOLVED] Nested If Statement - ISBLANK and ISNA in same statement?
    By Janc in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-23-2013, 09:00 AM
  6. IF ISBlank statement
    By orange86 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-06-2008, 11:50 AM
  7. Adding A Not(IsBlank) To IF Statement(help)
    By getmhawks in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2006, 05:50 PM

Bookmarks

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