DennisYoung
New Member
- Joined
- Jun 27, 2022
- Messages
- 14
- Office Version
- 2021
- 2016
- Platform
- Windows
I am very new to formula's so please be kind.
I am doing a formula for Credit Card types and if it is a Payment or Overpayment or Credit or Return then add cells I2 (PaymentAmnt) and J2 (Subtotal) to cell R2
I have tried =IF(OR(EXACT(G2="Payment",H2=CCardTypes!$A$1:$A$41)),I2+J2,"0.00") and it gives me data but when I add the second nest =IF(OR(EXACT(G2="Payment",H2=CCardTypes!$A$1:$A$41)),I2+J2,IF(OR(EXACT(G2="Overpayment",H2=CCardTypes!$A$1:$A$41)),I2+J2,"0.00")) it puts amounts into all the cells even if it is not on the Credit Card list
I am doing a formula for Credit Card types and if it is a Payment or Overpayment or Credit or Return then add cells I2 (PaymentAmnt) and J2 (Subtotal) to cell R2
I have tried =IF(OR(EXACT(G2="Payment",H2=CCardTypes!$A$1:$A$41)),I2+J2,"0.00") and it gives me data but when I add the second nest =IF(OR(EXACT(G2="Payment",H2=CCardTypes!$A$1:$A$41)),I2+J2,IF(OR(EXACT(G2="Overpayment",H2=CCardTypes!$A$1:$A$41)),I2+J2,"0.00")) it puts amounts into all the cells even if it is not on the Credit Card list