Kelleyscott
New Member
- Joined
- May 21, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
A1 (Fee) = $ Value
A2 (Lodged) = Yes/No
A3 (Type) = Multiple choices
A4 (Risk) = Yes/No
A5 (Option) = Fee Waiver
This IFS function does works but I would like to use an IF function so that rather than an #N/A response for False I would like "Declined"
=IFS(AND(A1<=30,A2="Yes",A3<>"Dishonour Fee - Auto",A5="Fee Waiver"),"APPROVED",AND(A3="Dishonour Fee - Auto",A4="Yes",B6="Fee Waiver"),"APPROVED")
Here are the requirements:
"Approved" = A1<=30 & A2 = "Yes" & A3<>"Dishonour Fee - Auto" & A5 = "Fee Waiver" ("Declined" if A1, A2, A3 or A5 has any other answer)
"Approved" = A3 = "Dishonour Fee - Auto" & A4 ="Yes" & A5 = "Fee Waiver" ("Declined if A3, A4 & A5 have any other answer)
A2 (Lodged) = Yes/No
A3 (Type) = Multiple choices
A4 (Risk) = Yes/No
A5 (Option) = Fee Waiver
This IFS function does works but I would like to use an IF function so that rather than an #N/A response for False I would like "Declined"
=IFS(AND(A1<=30,A2="Yes",A3<>"Dishonour Fee - Auto",A5="Fee Waiver"),"APPROVED",AND(A3="Dishonour Fee - Auto",A4="Yes",B6="Fee Waiver"),"APPROVED")
Here are the requirements:
"Approved" = A1<=30 & A2 = "Yes" & A3<>"Dishonour Fee - Auto" & A5 = "Fee Waiver" ("Declined" if A1, A2, A3 or A5 has any other answer)
"Approved" = A3 = "Dishonour Fee - Auto" & A4 ="Yes" & A5 = "Fee Waiver" ("Declined if A3, A4 & A5 have any other answer)