SOLVED

IFS vs SumProduct

%3CLINGO-SUB%20id%3D%22lingo-sub-3351808%22%20slang%3D%22en-US%22%3EIFS%20vs%20SumProduct%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3351808%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20searching%20for%20formula%20help%20and%20nothing%20I've%20found%20seems%20to%20be%20the%20answer.%20Any%20help%20would%20be%20greatly%20appreciated!%20Here's%20what%20I'm%20trying%20to%20do%3A%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20column%20(C)%20where%20the%20value%20will%20either%20be%2010%20or%2020.%20If%20the%20value%20is%2010%2C%20I'd%20like%20the%20value%20in%20column%20F%20to%20carryover%20to%20column%20G.%20If%20the%20value%20is%2020%2C%20I'd%20like%20the%20value%20in%20column%20F%20to%20be%20multiplied%20by%202%20and%20that%20value%20dropped%20in%20column%20G.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3351808%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-3352024%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20vs%20SumProduct%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3352024%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386042%22%20target%3D%22_blank%22%3E%40K_Shepherd%3C%2FA%3E%26nbsp%3BLet's%20say%20you%20want%20to%20enter%20such%20a%20formula%20in%20G1%2C%20use%20a%20formula%20like%20%26nbsp%3B%3CSTRONG%3E%3DC1%2F10*F1%20%3C%2FSTRONG%3Eand%20copy%20it%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3352030%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20vs%20SumProduct%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3352030%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386042%22%20target%3D%22_blank%22%3E%40K_Shepherd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIFS(C1%3D10%2CF1%2CC1%3D20%2CF1*2)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EMaybe%20with%20this%20formula.%20It%20is%20possible%20to%20use%20SUMPRODUCT%20in%20order%20to%20calculate%20the%20total%20of%20range%20G1%3AG14%20which%20is%20141%20in%20the%20attached%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3352034%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20vs%20SumProduct%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3352034%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20worked!%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I've been searching for formula help and nothing I've found seems to be the answer. Any help would be greatly appreciated! Here's what I'm trying to do: 

I have a column (C) where the value will either be 10 or 20. If the value is 10, I'd like the value in column F to carryover to column G. If the value is 20, I'd like the value in column F to be multiplied by 2 and that value dropped in column G.  

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@K_Shepherd Let's say you want to enter such a formula in G1, use a formula like  =C1/10*F1 and copy it down.

It worked! Thanks!