Home

Help with a formula... I've tried everything!

%3CLINGO-SUB%20id%3D%22lingo-sub-677823%22%20slang%3D%22en-US%22%3EHelp%20with%20a%20formula...%20I've%20tried%20everything!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677823%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20make%20what%20i%20thought%20would%20be%20a%20simple%20product%20formula%2C%20but%20-%20I%20am%20stuck.%20Any%20help%20would%20be%20appreciated!%20I%20will%20write%20the%20actual%20formula%20times%20column%20B3%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DPRODUCT(B3%3A(%240.45%20%2B%20%5B(%2453.21%20-%20%2425.00)%20x%20.01%5D%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-677823%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-677854%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20formula...%20I've%20tried%20everything!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677854%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356588%22%20target%3D%22_blank%22%3E%40BAS_1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20may%20explain%20on%20small%20sample%20file%20what%20you'd%20like%20to%20do.%20It's%20bit%20hard%20to%20make%20a%20guess%20what%20it%20shall%20be%20based%20on%20your%20expression.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-677868%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20formula...%20I've%20tried%20everything!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677868%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-677886%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20formula...%20I've%20tried%20everything!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356588%22%20target%3D%22_blank%22%3E%40BAS_1%3C%2FA%3E%26nbsp%3B%2C%20you'd%20like%20to%20multiply%20B3%20on%20something%20or%20what%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
BAS_1
New Contributor

I am trying to make what i thought would be a simple product formula, but - I am stuck. Any help would be appreciated! I will write the actual formula times column B3 below.

 

=PRODUCT(B3:($0.45 + [($53.21 - $25.00) x .01]

3 Replies

@BAS_1 

Perhaps you may explain on small sample file what you'd like to do. It's bit hard to make a guess what it shall be based on your expression. 

@BAS_1 , you'd like to multiply B3 on something or what?

Related Conversations