+ Reply to Thread
Results 1 to 3 of 3

Need help with a complex if statement

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    Kenosha
    MS-Off Ver
    O365
    Posts
    9

    Need help with a complex if statement

    I am working on a budget spreadsheet. I am trying to solve the problem

    Calculate 25%of the credit limit (goal amount), then subtract the current balance from the goal amount,
    if the goal amount <=0 then show me "OK"
    but, if the goal amount is >0 then show me what the value is.

    Cell A is Credit Limit
    Cell B is current balance

    for instance
    Cell A credit limit is 1000
    Cell B is the current balance of 850

    In Cell C I want to show that since the current balance is greater than the goal amount (1000*.25=250) I want it to display 600 since that is the difference between the current balance and the goal amount

  2. #2
    Registered User
    Join Date
    03-23-2020
    Location
    UMINA BEACH, NSW
    MS-Off Ver
    2019
    Posts
    21

    Re: Need help with a complex if statement

    G'day mate

    In cell C1 input =IF(A1*0.25<B1,B1-A1*0.25,"OK")

    Hope this helps, H

  3. #3
    Registered User
    Join Date
    03-26-2020
    Location
    Kenosha
    MS-Off Ver
    O365
    Posts
    9

    Red face Re: Need help with a complex if statement

    Thank You!!!

+ 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] Complex IF/AND/OR/THEN Statement
    By madouxan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-14-2019, 03:35 PM
  2. Complex If Statement
    By exc1967 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2016, 11:52 AM
  3. Complex IF Statement
    By Shadmani in forum Excel General
    Replies: 4
    Last Post: 12-29-2015, 10:39 AM
  4. complex if statement
    By young_eeyore in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-11-2015, 07:37 PM
  5. [SOLVED] Help with complex If statement please
    By TimJ79 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2014, 12:35 PM
  6. Complex IF Statement
    By rhudgins in forum Excel General
    Replies: 1
    Last Post: 03-14-2011, 06:15 PM
  7. complex if statement
    By snoopy990 in forum Excel General
    Replies: 5
    Last Post: 06-02-2009, 01:21 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