SOLVED
Home

Help with If Formula with Multiple Calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-861499%22%20slang%3D%22en-US%22%3EHelp%20with%20If%20Formula%20with%20Multiple%20Calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861499%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20calculate%20an%20If%20Formula%20with%20multiple%20options%20and%20I%20have%20the%201st%20part%2C%20but%20no%20clue%20how%20to%20move%20forward.%20My%20initial%20formula%20is%3A%3C%2FP%3E%3CP%3E%3DIF(C7%26lt%3B%3D128400%2C(C7*.9235)*.153%2F2)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20add%20the%20formula%20for%20when%20the%20amount%20in%20C7%20is%20greater%20than%20128%2C400%3F%3C%2FP%3E%3CP%3EIf%20greater%20than%20128%2C400%2C%20I%20need%20the%20following%20calculation%20(C7*.9235)*.029%2B15921.60%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20adding%20the%20entire%20string%20together%2C%20but%20keep%20getting%20an%20error%20message%20when%20I%20did%20this%3A%3C%2FP%3E%3CP%3E%3DIF(C7%26lt%3B%3D128%2C400%2C(C7*0.9235)*0.153%2F2)%2CIF(C7%26gt%3B128400%2C(C7*0.9235)*0.029%2B15921.6)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20HELP!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861499%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-861576%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20If%20Formula%20with%20Multiple%20Calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411222%22%20target%3D%22_blank%22%3E%40MrsRandle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(C7%26gt%3B128400%2CC7*0.9235*0.029%2B15921.6%2CC7*0.9235*0.153%2F2)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
MrsRandle
Occasional Visitor

I am trying to calculate an If Formula with multiple options and I have the 1st part, but no clue how to move forward. My initial formula is:

=IF(C7<=128400,(C7*.9235)*.153/2)

 

How do I add the formula for when the amount in C7 is greater than 128,400?

If greater than 128,400, I need the following calculation (C7*.9235)*.029+15921.60

 

I tried adding the entire string together, but keep getting an error message when I did this:

=IF(C7<=128,400,(C7*0.9235)*0.153/2),IF(C7>128400,(C7*0.9235)*0.029+15921.6)

 

Please HELP!

 

 

1 Reply
Solution

@MrsRandle 

That could be

=IF(C7>128400,C7*0.9235*0.029+15921.6,C7*0.9235*0.153/2)

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies