IF Function multiple parameters

%3CLINGO-SUB%20id%3D%22lingo-sub-2693731%22%20slang%3D%22en-US%22%3EIF%20Function%20multiple%20parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2693731%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20trouble%20creating%20a%20formula%20where%20if%20the%20combined%20annual%20is%20less%20than%20cap%20and%20if%20the%20combined%20total%20is%20over%20the%20cap%20and%20if%20the%20combined%20amount%20is%20over%20in%20the%201st%20quarter%20to%20show%20only%20the%20residual%20amount.%20if%20the%20cap%20is%2075000%20and%20the%201st%20Qtr%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3Bthey%20earned%2075000%201st%20Qtr%20payment%20should%20be%2075000%20the%20second%20Qtr%20amount%20would%20be%20zero%20due%20to%20cap.%20What%20if%20the%20amount%20of%20the%201st%20and%20second%20qtr%20combined%20was%20more%20than%20the%20cap%20and%20the%201st%20qtr%20was%20less%20in%20need%20the%20amount%20for%202nd%20Qtr%20payment%20to%20be%20the%20difference%20(Row%207)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2693731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2693884%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20multiple%20parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2693884%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1139722%22%20target%3D%22_blank%22%3E%40Andympli%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attachment.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am having trouble creating a formula where if the combined annual is less than cap and if the combined total is over the cap and if the combined amount is over in the 1st quarter to show only the residual amount. if the cap is 75000 and the 1st Qtr 

 they earned 75000 1st Qtr payment should be 75000 the second Qtr amount would be zero due to cap. What if the amount of the 1st and second qtr combined was more than the cap and the 1st qtr was less in need the amount for 2nd Qtr payment to be the difference (Row 7)

 

Please help

 

1 Reply

@Andympli 

See the attachment.