SOLVED

IFS function

%3CLINGO-SUB%20id%3D%22lingo-sub-2921837%22%20slang%3D%22en-US%22%3EIFS%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2921837%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20having%20a%20problem%20with%20the%20IFS%20function.%26nbsp%3B%20Not%20sure%20if%20I'm%20using%20the%20correct%20function.%26nbsp%3B%20I%20am%20trying%20do%20a%20function%20on%20the%20attached%20spreadsheet%20that%20says%20in%20the%20CC%20Fees%20box%2C%20if%20G2%20is%20Credit%20or%20Debit%2C%20then%20times%20E2%20by%20.03.%26nbsp%3B%20I%20must%20be%20getting%20the%20syntax%20wrong%20because%20it%20doesn't%20work%20when%20I'm%20trying%20to%20put%20it%20in.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2921837%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2921993%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2921993%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1205627%22%20target%3D%22_blank%22%3E%40Stingray13485%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(OR(G2%3D%22Credit%22%2CG2%3D%22Debit%22)%2CE2*0.03)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIFS(OR(%3C%2FSPAN%3E%3CSPAN%3EG2%3C%2FSPAN%3E%3CSPAN%3E%3D%22Credit%22%2C%3C%2FSPAN%3E%3CSPAN%3EG2%3C%2FSPAN%3E%3CSPAN%3E%3D%22Debit%22)%2C%3C%2FSPAN%3E%3CSPAN%3EE2%3C%2FSPAN%3E%3CSPAN%3E*0%2C03)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20the%20formula%20you%20are%20looking%20for%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2922038%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2922038%22%20slang%3D%22en-US%22%3EOMGosh%2C%20thank%20you%20sooooo%20much!%20It%20worked.%20You're%20a%20genius.%20I%20wish%20I%20knew%20more%20about%20formulas!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2922055%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2922055%22%20slang%3D%22en-US%22%3EOne%20more%20question...I%20have%20a%20formula%20in%20the%20sheet%20already%20that%20copies%20all%20the%20info%20into%20other%20sheets%20automatically.%20Can%20I%20use%20the%20formula%20you%20gave%20me%20also%3F%20Thanks!%3C%2FLINGO-BODY%3E
New 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!