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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies