# Need help with a complex if statement

1. ## 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. ## 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. ## Re: Need help with a complex if statement

Thank You!!!

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

#### 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