SOLVED
Home

Simple =IF function question

%3CLINGO-SUB%20id%3D%22lingo-sub-763452%22%20slang%3D%22en-US%22%3ESimple%20%3DIF%20function%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-763452%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20tracking%20monthly%20loan%20payments.%20Column%20I%20indicates%20whether%20the%20bill%20has%20been%20paid%20yet%20with%20a%20simple%20%22yes%22%20or%20%22no%22%20value%2C%20and%20Column%20J%20indicates%20the%20remaining%20balance%20of%20the%20loan.%20I%20want%20every%20cell%20in%20Column%20I%20of%20my%20worksheet%20to%20confirm%20whether%20or%20not%20the%20remaining%20balance%20has%20been%20entered%20into%20the%20adjacent%20cell%20in%20Column%20J.%20The%20value%20entered%20into%20each%20cell%20in%20Column%20J%20is%20a%20subtraction%20of%20the%20value%20in%20the%20preceding%20J%20cell%20and%20a%20value%20in%20cell%20L5.%20If%20a%20cell%20in%20Column%20J%20does%20not%20have%20that%20value%20entered%2C%20I%20want%20Column%20I%20to%20reflect%20that%20with%20%22no%22%3B%20if%20Column%20J%20does%20have%20that%20value%2C%20I%20want%20Column%20I%20to%20reflect%20with%20%22yes%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20equation%20I%20started%20with%20and%20would%20love%20some%20help%20figuring%20this%20out.%20Screenshot%20of%20the%20table%20included.%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(OR(J8-L5%2C%20%22yes%22%2C%20%22no%22))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-763452%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-763462%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20%3DIF%20function%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-763462%22%20slang%3D%22en-US%22%3EEnter%20this%20formula%20in%20I8%3A%3CBR%20%2F%3E%3DIF(ISNUMBER(J8)%2C%3CBR%20%2F%3E%E2%80%9CYes%E2%80%9D%2C%3CBR%20%2F%3E%E2%80%9CNo%E2%80%9D)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-763467%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20%3DIF%20function%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-763467%22%20slang%3D%22en-US%22%3EBrilliant%2C%20Thank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-763484%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20%3DIF%20function%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-763484%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20welcome.%3C%2FLINGO-BODY%3E
chickadee
New Contributor

I am tracking monthly loan payments. Column I indicates whether the bill has been paid yet with a simple "yes" or "no" value, and Column J indicates the remaining balance of the loan. I want every cell in Column I of my worksheet to confirm whether or not the remaining balance has been entered into the adjacent cell in Column J. The value entered into each cell in Column J is a subtraction of the value in the preceding J cell and a value in cell L5. If a cell in Column J does not have that value entered, I want Column I to reflect that with "no"; if Column J does have that value, I want Column I to reflect with "yes".

 

This is the equation I started with and would love some help figuring this out. Screenshot of the table included. Thanks!

 

=IF(OR(J8-L5, "yes", "no"))

3 Replies
Solution
Enter this formula in I8:
=IF(ISNUMBER(J8),
“Yes”,
“No”)
Brilliant, Thank you!
You’re welcome.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies