• 463K Members
• 5,940 Online
• 560K Conversations
SOLVED

New Contributor

# Simple =IF function question

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

# Re: Simple =IF function question

Enter this formula in I8:
=IF(ISNUMBER(J8),
“Yes”,
“No”)

# Re: Simple =IF function question

Brilliant, Thank you!

# Re: Simple =IF function question

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