+ 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
    2

    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
    2016
    Posts
    1

    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
    2

    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)

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