Clubbing 2 if conditions into one

[ansvk1]

Hi there,
i heard there are a lot of ways to do nested if s. But i am not sure on how to nest my situation. Your help with this will be greatly appreciated.

Here is my situation:

1. i am uploading my spreadsheet for your ref.
2. Based on cell value input given in C22, my output cells E83 has to work.
3. But as of now i could only make figure out the If conditions to work correctly by writing their formulas separately
   • currently, When C22 is "USDA", my good/working IF formula is in E83 (output all correct the way wanted/expected
   • currently, When C22 is not "USDA" or "non Blank", my good/working IF formula is in E81 (output all correct the way wanted/expected
4. NOW, how do I club both these IF formulas into one cell E83 as a good/working output? so that both individual If formulas i have written are working with out conflicting.

your help is very much appreciated!
thanks again,
Krishna

attaching my Mini-sheet for your ref:

Book14Explaing the issue.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
2	FLOOD INSURANCE		NOTES	Key:
3
4		1/31/2022		= Fill in Cell
5		2/7/2022		= Missing Data
6		111111111111		= Inadequate Coverage
7		Smiht, Carrie & Ben		= WARNING
8		123 Main St
9		C/S, CO 80923
10	Loan Type	Portfolio
11	Loan Transaction Type	Purchase
12		Primary
13		KA
14
15	General Loan Information		NOTES
16
17		$350,000.00
18		$0.00
19	Total Outstanding Liens	$350,000.00
20
21	Structures at Risk		NOTES
22
23
24	What is the replacement cost value of the structure(s) at risk?
25	Structure 1	$10,000.00		ADD 10% TO RCV TO COVER FOUNDATION
26	Structure 2	$0.00
27	Structure 3	$0.00
28	Structure 4	$0.00
29	Structure 5	$0.00
30	Total Replacement Costs	$10,000.00
31
32	Structure 1	Replacement Cost Value from Hazard Insurance							Replacement Cost Value from Hazard Insurance	Dwelling Coverage Value from Hazard Insurance	Total Estimate of Cost-New from Appraisal
33	Structure 2
34	Structure 3
35	Structure 4
36	Structure 5
37
38	Structure 1	Yes
39	Structure 2
40	Structure 3
41	Structure 4
42	Structure 5
43
44	Structure 1
45	Structure 2
46	Structure 3
47	Structure 4
48	Structure 5
49	Total Value of Contents	0.00
50	The minimum amount of flood insurance required for this loan is	$10,000.00
51
52	DETERMINATION OF ADEQUACY		NOTES
53		01/31/2022
54		AE							A1	A1-A30	A99	AE	AH	AO	B	C	D	V	VE	V1-V30	VO	X	X500	XS	XU
55		AE
56		AE
57		1/20/2022
58		1/20/2022
59	Flood Invoice Review
60		Yes
61		Yes
62		$1,500.00
63		$125.00
64	Flood Policy Review
65	Dec Page/Policy received? Note: Application/Binders/Quote are not acceptable proof of insurance.	Yes
66	Is the policy an SFIP Policy issued directly from FEMA or an authorized WYO insurance company? Website: https://nfipservices.floodsmart.gov/wyo-program-list	Yes	Enter Name of Flood Insurance Company	STOP. SEARCH THE FEMA WYO LIST AND UPLOAD PRINTOUT INTO THE APPLICABLE INSURANCE EFOLDER.
67	Flood Policy Number?	1234567891234560
68	Policy Effective Date? Note: Must be on or before closing date.	2/7/2022
69	Policy Expiration/Renewal Date?	1/31/2023		STOP. CONV/FHA/VA LOANS - DEDUCTIBLE CANNOT EXCEED $10,000.
70	Dwelling Coverage on Flood Policy?	$600,000.00	FALSE	FALSE
71	Deductible Amount? Note: Cannot exceed $10,000. Note: If USDA - Cannot exceed the greater of $1,000, 1% of policy coverage, or the minimum deductible offered by insurance carrier	$10,500.00	$6,000.00	STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE.
72	Is Bank listed as a loss payee? Note: Bank will not be a loss payee if the loan is participation. If you have questions, contact the Compliance Department.	Yes
73		No	this C85 has to be YES/NO for C94 to be YES?? Not Programming for now
74		No	This has to be No for C94 to be Yes.
75		Yes
76		Yes
77		Yes
78		Yes
79		Yes
80		Yes
81		Yes
82	DOES THE POLICY MEET BOEM REQUIREMENTS?	No	Calculates Yes/No based of all questions answered.
83	Minimum Amount of Insurance Required	$10,000.00	Must be the lessor of c62 or c96, exclude $0 value BUT Max coverage 250K.
84	Amount of Flood Insurance in Place or Applied For	$600,000.00
85	IS THE AMOUNT OF INSURANCE ADEQUATE?	Yes
86	ADDITIONAL FLOOD INSURANCE REQUIRED IN THE AMOUN OF?	-590000.00	If = to or greater than zero should, Cell C98 TO highlight in maroon box like C94.
87	PROCEED TO CLOSE?	No	both C94 or C97 must be Yes in order to proceed
Flood insu

Cell Formulas
Range	Formula
E10	E10	=IF(AND(C10="USDA",C71*0.01>=1000),"STOP. FOR USDA, DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF DWELLING COVERAGE.","")
C19	C19	=SUM(C17:C18)
E25:E29	E25	=IF(AND(C25>0,C32="Replacement Cost Value from Hazard Insurance"), "ADD 10% TO RCV TO COVER FOUNDATION", "")
C30,C49	C30	=SUM(C25:C29)
C50	C50	=IF('C:\Users\Sri&Naveen\Documents\BOEM_work\Processing\Flood Calc\[BOE_FloodInsuCalc_RBG_Draft7_KA.xlsx]Res Multi Family Calc'!M3<'C:\Users\Sri&Naveen\Documents\BOEM_work\Processing\Flood Calc\[BOE_FloodInsuCalc_RBG_Draft7_KA.xlsx]Res Multi Family Calc'!M16,'C:\Users\Sri&Naveen\Documents\BOEM_work\Processing\Flood Calc\[BOE_FloodInsuCalc_RBG_Draft7_KA.xlsx]Res Multi Family Calc'!M3,'C:\Users\Sri&Naveen\Documents\BOEM_work\Processing\Flood Calc\[BOE_FloodInsuCalc_RBG_Draft7_KA.xlsx]Res Multi Family Calc'!M16)
E55	E55	=IF(C54=C55,"","STOP. MUST MATCH THE FLOOD ZONE ON THE FLOOD CERTIFICATE.")
E56	E56	=IF(C56=C54,"","STOP. MUST MATCH FLOOD ZONE ON THE FLOOD CERTIFICATE.")
E60	E60	=IF(C60="No","STOP. OBTAIN PAID IN FULL INVOICE. COLLECTING AT CLOSING IS PROHIBITED.","")
E61	E61	=IF(C61="No","STOP. BORROWER MUST PAY PREMIUM UPFRONT. CANNOT BE PAID AT CLOSING. OBTAIN A PAID IN FULL INVOICE WITH $0 BALANCE DUE. ","")
C63	C63	=C62/12
E65	E65	=IF(C65="No","STOP. OBTAIN DECLARATIONS PAGE OR POLICY.","")
E66	E66	=IF(C66="No","STOP. COMPLETE THE PRIVATE FLOOD INSURANCE TAB. FHA REQUIRES AN NFIP POLICY AS PRIVATE POLICIES ARE PROHIBITED.",IF(C66="Yes","STOP. SEARCH THE FEMA WYO LIST AND UPLOAD PRINTOUT INTO THE APPLICABLE INSURANCE EFOLDER.",""))
D69	D69	=IF(AND(C10<>"USDA",C10<>""),"")
D70	D70	=C10="USDA"
D71	D71	=C70*0.01
E69	E69	=IF(C71>=10000,"STOP. CONV/FHA/VA LOANS - DEDUCTIBLE CANNOT EXCEED $10,000.","")
E70	E70	=C71<=MAX(1000,C70*0.01)
E71	E71	=IF(AND(C10="USDA",C71<=MAX(1000,C70*0.01)),"","STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE.")
E72	E72	=IF(C72="No","STOP. CONTACT THE FLOOD INSURANCE COMPANY TO REVISE MORTGAGE CLAUSE.","")
E73	E73	=IF(C73="Yes","STOP. OBTAIN FULLY EXECUTED TRANSFER APPLICATION SIGNED BY ALL PARTIES.","")
E74	E74	=IF(C74="Yes","STOP. BORROWER TO OBTAIN A NEW FLOOD POLICY AS FORCED PLACE POLICIES ARE PROHIBITED.","")
E75:E76	E75	=IF(C75="No","STOP. COMPLETE PROR TO BOE FLOOD REVIEW SUBMISSION.","")
E81,E77:E78	E77	=IF(C77="No","STOP. COMPLETE PRIOR TO BOE FLOOD REVIEW SUBMISSION.","")
E79	E79	=IF(C79="No","STOP. COMPLETE PRIOR TO BOE FLOOD REVIEW SUBMISSION. ","")
E80	E80	=IF(C80="No","STOP. COMPLETE PRIOR TO BOE FLOOD REVIEW SUBMISSION. PREMIUM MUST REFLECT AS POC.","")
C82	C82	=IF(COUNTIFS(C65:C81,"Yes")=13,"Yes","No")
C83	C83	=C50
C84	C84	=C70
C85	C85	=IF(C84>=C83,"Yes","No")
C86	C86	=C83-C84
C87	C87	=IF(COUNTIF(C82:C85,"yes")=2,"Yes","No")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E10	Cell Value	contains "STOP"	text	NO
E60	Cell Value	contains "STOP"	text	NO
E66	Cell Value	contains "STOP"	text	NO
C66	Cell Value	contains "Yes"	text	NO
C74	Cell Value	contains "Yes"	text	NO
C73	Cell Value	contains "Yes"	text	NO
C54:C58,C62:C63	Cell	contains a blank value	text	NO
C56	Expression	=IF($C$56=$C$54, FALASE, TRUE)	text	NO
C36	Expression	=IF(AND($C$36="",$C$29>0),TRUE,FALSE)	text	NO
C36	Cell Value	="Cost"	text	NO
C36	Cell Value	="Total"	text	NO
C36	Cell Value	="Dwelling"	text	NO
C35	Expression	=IF(AND($C$35="",$C$28>0),TRUE,FALSE)	text	NO
C35	Cell Value	="Cost"	text	NO
C35	Cell Value	="Total"	text	NO
C35	Cell Value	="Dwelling"	text	NO
C34	Expression	=IF(AND($C$34="",$C$27>0),TRUE,FALSE)	text	NO
C34	Cell Value	="Cost"	text	NO
C34	Cell Value	="Total"	text	NO
C34	Cell Value	="Dwelling"	text	NO
C33	Expression	=IF(AND($C$33="",$C$26>0),TRUE,FALSE)	text	NO
C33	Cell Value	="Cost"	text	NO
C33	Cell Value	="Total"	text	NO
C33	Cell Value	="Dwelling"	text	NO
C60	Cell	contains a blank value	text	NO
E56	Cell Value	contains "STOP"	text	NO
E55	Cell Value	contains "STOP"	text	NO
E71	Cell Value	contains "STOP"	text	NO
E69	Cell Value	contains "STOP"	text	NO
E66	Cell Value	contains "SEARCH"	text	NO
E81	Cell Value	contains "STOP"	text	NO
C75	Cell Value	contains "No"	text	NO
C48	Expression	=IF(AND($C$42="Yes",$C$48<=0),TRUE,FALSE)	text	NO
C48	Expression	=IF($C$42="No",TRUE,FALSE)	text	YES
C47	Expression	=IF(AND($C$41="Yes",$C$47<=0),TRUE,FALSE)	text	NO
C46	Expression	=IF(AND($C$40="Yes",$C$46<=0),TRUE,FALSE)	text	NO
C45	Expression	=IF(AND($C$39="Yes",$C$45<=0),TRUE,FALSE)	text	NO
C47	Expression	=IF($C$41="No",TRUE,FALSE)	text	YES
C46	Expression	=IF($C$40="No",TRUE,FALSE)	text	YES
C45	Expression	=IF($C$39="No",TRUE,FALSE)	text	YES
C44	Expression	=IF(AND($C$38="Yes",$C$44<=0),TRUE,FALSE)	text	NO
C32	Expression	=IF(AND($C$32="",$C$25>0),TRUE,FALSE)	text	NO
C32	Cell Value	="Cost"	text	NO
C32	Cell Value	="Total"	text	NO
C32	Cell Value	="Dwelling"	text	NO
C87	Cell Value	="No"	text	NO
C85:C86	Cell Value	="No"	text	NO
C65	Cell Value	contains "No"	text	NO
C65	Cell	contains a blank value	text	NO
C85:C86	Cell Value	="No"	text	NO
C82	Cell Value	="No"	text	NO
E80	Cell Value	contains "STOP"	text	NO
E79	Cell Value	contains "STOP"	text	NO
E77	Cell Value	contains "STOP"	text	NO
E78	Cell Value	contains "STOP"	text	NO
C77:C81	Cell Value	contains "No"	text	NO
C77:C81	Cell	contains a blank value	text	NO
E75:E76	Cell Value	beginning with "STOP"	text	NO
C76	Cell Value	contains "No"	text	NO
C76	Cell	contains a blank value	text	NO
E72	Cell Value	contains "STOP"	text	NO
C72	Cell Value	contains "No"	text	NO
C72	Cell	contains a blank value	text	NO
E61	Cell Value	contains "Borrower must pay premium upfront. Cannot be paid at closing. Obtain a paid in full invoice with $0 balance due."	text	NO
C61	Cell	contains a blank value	text	NO
C61	Cell Value	contains "No"	text	NO
E74	Cell Value	contains "BORROWER TO OBTAIN A NEW FLOOD POLICY AS FORCED PLACE POLICIES ARE PROHIBITED."	text	NO
E73	Cell Value	contains "OBTAIN FULLY EXECUTED TRANSFER APPLICATION SIGNED BY ALL PARTIES."	text	NO
E65	Cell Value	contains "OBTAIN DECLARATIONS PAGE OR POLICY."	text	NO
C62:C63	Cell	contains a blank value	text	NO
C70:C71	Cell	contains a blank value	text	NO
C58,C62:C63	Cell	contains a blank value	text	NO
C11	Cell	contains a blank value	text	NO
C10	Cell	contains a blank value	text	NO
C5	Cell	contains a blank value	text	NO
C66:C67	Cell Value	contains "No"	text	NO
C66:C67	Cell	contains a blank value	text	NO
E25:E29	Cell Value	="ADD 10% TO RCV TO COVER FOUNDATION"	text	NO
E25:E29	Cell Value	="ADD 10% TO OVERALL VALUE TO COVER FOUNDATION"	text	NO
C55	Expression	=IF($C$55=$C$54, FALASE, TRUE)	text	NO
C53	Cell	contains a blank value	text	NO
C4	Cell	contains a blank value	text	NO
C7	Cell	contains a blank value	text	NO
C8	Cell	contains a blank value	text	NO
C6,C12	Cell	contains a blank value	text	NO
D32:D36	Expression	=IF(AND($C$32="Other- Please specify in Notes section"),TRUE,FALSE)	text	NO
C31	Cell Value	=0	text	NO
C31	Cell	contains a blank value	text	NO
C83	Cell Value	=0	text	NO
C49	Cell Value	=0	text	NO
C49	Cell	contains a blank value	text	NO
C30	Cell Value	=0	text	NO
C30	Cell	contains a blank value	text	NO
C19	Cell Value	=0	text	NO
C19	Cell	contains a blank value	text	NO
C50	Cell Value	=0	text	NO
C83:C84	Cell	contains a blank value	text	NO
C25:C29	Cell	contains a blank value	text	NO
C38:C42	Cell	contains a blank value	text	NO
C44	Expression	=IF($C$38="No",TRUE,FALSE)	text	YES
C68	Expression	=IF(C5>=C68, FALSE,TRUE)	text	NO
D66	Cell Value	contains "Name of Flood Insurance Company"	text	NO
C60	Cell Value	contains "No"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
C32:C36	List	Replacement Cost Value from Hazard Insurance, Dwelling Coverage from Hazard Insurance, Total Estimate of Cost-New from Appraisal
C54:C56	List	=$J$54:$Z$54
C10	List	=#REF!
C11	List	Purchase,Refinance,New Construction
C12	List	=#REF!
C72:C81	List	Yes, No
C60:C61	List	Yes, No
C65:C66	List	Yes, No
C38:C42	List	Yes, No

 

[etaf]

i dont seem to be able to find the IF you are refering to in that XL2BB

1. But as of now i could only make figure out the If conditions to work correctly by writing their formulas separately
   • currently, When C22 is "USDA", my good/working IF formula is in E83 (output all correct the way wanted/expected
   • currently, When C22 is not "USDA" or "non Blank", my good/working IF formula is in E81 (output all correct the way wanted/expected

Also referred to external links
What are the 2 IF's you are trying to combine
and the results expected

E81 & E83 , does not have anything I can see

 

[ansvk1]

i dont seem to be able to find the IF you are refering to in that XL2BB


Also referred to external links
What are the 2 IF's you are trying to combine
and the results expected

E81 & E83 , does not have anything I can see

I am sorry, i have accidentally removed some logos and stuff on the top before uploading the mini sheet and did not realize it would move everything up. How do I update my mini sheet with correct cells, formulas i referred to in my original question?

 

[etaf]

can you just post the 2 IFs and desired results
May be able to work out

you can edit the post after 10mins, so you would need to post a reply with the new mini sheet

just not sure how confused i may get with such a big sample - but happy to try

 

[ansvk1]

here is the correct mini sheet with final intent of Clubbing Cell formulas in E81 and E83 into E83 with out loosing the conditions.

Book14Explaing the issue.xlsx
	B	C	D	E
73	Loan Type (this value used to be shown in C22, but now moved to C73 for ease of viewing in mini sheet)	USDA	C73 here was C22 in my orginal post, had to move to shrink the size of mini sheet.
74	Loan Transaction Type	Purchase
75
76	Flood Policy Review
77
78
79	Flood Policy Number?	1234567891234560
80	Policy Effective Date? Note: Must be on or before closing date.	2/7/2022
81	Policy Expiration/Renewal Date?	1/31/2023		STOP. CONV/FHA/VA LOANS - DEDUCTIBLE CANNOT EXCEED $10,000.
82	Dwelling Coverage on Flood Policy?	$600,000.00
83	Deductible Amount? Note: Cannot exceed $10,000. Note: If USDA - Cannot exceed the greater of $1,000, 1% of policy coverage, or the minimum deductible offered by insurance carrier	$10,500.00		STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE.
Flood insu

Cell Formulas
Range	Formula
E81	E81	=IF(C83>=10000,"STOP. CONV/FHA/VA LOANS - DEDUCTIBLE CANNOT EXCEED $10,000.","")
E83	E83	=IF(AND(C73="USDA",C83<=MAX(1000,C82*0.01)),"","STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE.")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E78	Cell Value	contains "STOP"	text	NO
C78	Cell Value	contains "Yes"	text	NO
C66:C70,C75	Cell	contains a blank value	text	NO
E83	Cell Value	contains "STOP"	text	NO
E81	Cell Value	contains "STOP"	text	NO
E78	Cell Value	contains "SEARCH"	text	NO
C77	Cell Value	contains "No"	text	NO
C77	Cell	contains a blank value	text	NO
E73	Cell Value	contains "Borrower must pay premium upfront. Cannot be paid at closing. Obtain a paid in full invoice with $0 balance due."	text	NO
E77	Cell Value	contains "OBTAIN DECLARATIONS PAGE OR POLICY."	text	NO
C75	Cell	contains a blank value	text	NO
C82:C83	Cell	contains a blank value	text	NO
C70,C75	Cell	contains a blank value	text	NO
C74	Cell	contains a blank value	text	NO
C73	Cell	contains a blank value	text	NO
C78:C79	Cell Value	contains "No"	text	NO
C78:C79	Cell	contains a blank value	text	NO
C80	Expression	=IF(C17>=C80, FALSE,TRUE)	text	NO
D78	Cell Value	contains "Name of Flood Insurance Company"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
C77:C78	List	Yes, No
C73	List	USDA, Conv, Portfolio, FHA
C74	List	Purchase,Refinance,New Construction

 

[ansvk1]

can you just post the 2 IFs and desired results
May be able to work out

you can edit the post after 10mins, so you would need to post a reply with the new mini sheet

just not sure how confused i may get with such a big sample - but happy to try

Dear Brother, kindly see if you can help me with this now?

 

[jtakw]

Hi,

Try this, Remove/Change "USDA" in C73 and/or values in C82, C83, and the formula will change output result:

Book3.xlsx
	B	C	D	E
73	Loan Type (this value used to be shown in C22, but now moved to C73 for ease of viewing in mini sheet)	USDA
74	Loan Transaction Type	Purchase
75
76	Flood Policy Review
77
78
79	Flood Policy Number?	1234567891234560
80	Policy Effective Date? Note: Must be on or before closing date.	2/7/2022
81	Policy Expiration/Renewal Date?	1/31/2023
82	Dwelling Coverage on Flood Policy?	600000
83	Deductible Amount? Note: Cannot exceed $10,000. Note: If USDA - Cannot exceed the greater of $1,000, 1% of policy coverage, or the minimum deductible offered by insurance carrier	10500		STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE.
Sheet1023

Cell Formulas
Range	Formula
E83	E83	=IF(C73="USDA",IF(C83<=MAX(1000,C82*0.01),"","STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE."),IF(C83>=10000,"STOP. CONV/FHA/VA LOANS - DEDUCTIBLE CANNOT EXCEED $10,000.",""))

 

[ansvk1]

Hi,

Try this, Remove/Change "USDA" in C73 and/or values in C82, C83, and the formula will change output result:

Book3.xlsx
	B	C	D	E
73	Loan Type (this value used to be shown in C22, but now moved to C73 for ease of viewing in mini sheet)	USDA
74	Loan Transaction Type	Purchase
75
76	Flood Policy Review
77
78
79	Flood Policy Number?	1234567891234560
80	Policy Effective Date? Note: Must be on or before closing date.	2/7/2022
81	Policy Expiration/Renewal Date?	1/31/2023
82	Dwelling Coverage on Flood Policy?	600000
83	Deductible Amount? Note: Cannot exceed $10,000. Note: If USDA - Cannot exceed the greater of $1,000, 1% of policy coverage, or the minimum deductible offered by insurance carrier	10500		STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE.
Sheet1023

Cell Formulas
Range	Formula
E83	E83	=IF(C73="USDA",IF(C83<=MAX(1000,C82*0.01),"","STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE."),IF(C83>=10000,"STOP. CONV/FHA/VA LOANS - DEDUCTIBLE CANNOT EXCEED $10,000.",""))

Yes. Here is the challenge:

I have two IF formulas (E81,E83) that work well/correctly based on C73 value input that will change based on case to case. Now i wanted to have a nested IF written to club both of these IFs into one cell (E83)

 

[jtakw]

I did that in my post #7 above. Did you Not see it ???

=IF(C73="USDA",IF(C83<=MAX(1000,C82*0.01),"","STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE."),IF(C83>=10000,"STOP. CONV/FHA/VA LOANS - DEDUCTIBLE CANNOT EXCEED $10,000.",""))

 

[ansvk1]

I did that in my post #7 above. Did you Not see it ???

=IF(C73="USDA",IF(C83<=MAX(1000,C82*0.01),"","STOP. USDA LOANS - DEDUCTIBLE CANNOT EXCEED THE GREATER OF $1,000 OR 1% OF THE POLICY COVERAGE."),IF(C83>=10000,"STOP. CONV/FHA/VA LOANS - DEDUCTIBLE CANNOT EXCEED $10,000.",""))

oh i am sorry, i did not realize that you did. thanks...i will test it out in my spread sheet and then