SOLVED

IFS function

Copper Contributor

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.

4 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Stingray13485 

=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?

OMGosh, thank you sooooo much! It worked. You're a genius. I wish I knew more about formulas!
One more question...I have a formula in the sheet already that copies all the info into other sheets automatically. Can I use the formula you gave me also? Thanks!
NM, I figured it out....thank you so much again! :)
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@Stingray13485 

=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?

View solution in original post