Nov 03 2021 08:54 AM
Hi, I am having a problem with the IFS function. Not sure if I'm using the correct function. I am trying do a function on the attached spreadsheet that says in the CC Fees box, if G2 is Credit or Debit, then times E2 by .03. I must be getting the syntax wrong because it doesn't work when I'm trying to put it in.
Nov 03 2021 09:12 AM
Solution=IF(OR(G2="Credit",G2="Debit"),E2*0.03)
=IFS(OR(G2="Credit",G2="Debit"),E2*0,03)
Is this the formula you are looking for?
Nov 03 2021 09:20 AM
Nov 03 2021 09:23 AM
Nov 03 2021 09:12 AM
Solution=IF(OR(G2="Credit",G2="Debit"),E2*0.03)
=IFS(OR(G2="Credit",G2="Debit"),E2*0,03)
Is this the formula you are looking for?