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
Bookmarks