Nested IF statements based on checkbox

I’m struggling to combine some IF statements. Basically…

If the {H06} column IS checked, I want it to apply this formula:
IF({Dwelling}>=MIN({Est Value},{App Value})*0.2,“OK”, “Insufficient”)

If the {H06} column is NOT checked, I want it to apply this formula:
IF({Dwelling}>={Loan Amt},“OK”, “Insufficient”)

Can anyone help me with syntax?

@karinav

Here you go:

IF({H06}, 
   IF({Dwelling} >= MIN({Est Value}, {App Value}) * 0.2, "OK", "Insufficient"),
   IF({Dwelling} >= {Loan Amt}, "OK", "Insufficient")
)

Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or Excel)

@JCorrell, THANK YOU! That was simpler than I thought. I appreciate it. It worked!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.