Calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-1623307%22%20slang%3D%22en-US%22%3ECalculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623307%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20set%20up%20a%20column%20to%20subtract%20a%20fee%20from%20my%20load%20amount.%20The%20fee%20is%203%25%20of%20every%20%24100%20and%20when%20i%20put%20it%20in.%20It%20takes%20the%20total%20amount%20and%20just%20subtracts%203%25.%20Say%20the%20load%20amount%20is%20%24950%2C%20It%20would%20need%20to%20take%203%25%20of%20every%20%24100%2C%20which%20would%20be%2027%25.%20making%20the%20total%20%24693.50%20(roughly%20if%20i%20did%20the%20math%20correctly)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1623307%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-1623371%22%20slang%3D%22en-US%22%3ERe%3A%20Calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F777081%22%20target%3D%22_blank%22%3E%40triplevitruckingllc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DA1*(1-INT(A1%2F100)*3%25)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eif%20I%20understood%20your%20logic%20correctly%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623393%22%20slang%3D%22en-US%22%3ERe%3A%20Calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623393%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%3CP%3EThank%20you%20very%20much.%20I%20am%20in%20the%20process%20of%20relearning%20how%20to%20use%20this%20program.%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20time%20and%20help%20are%20very%20much%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to set up a column to subtract a fee from my load amount. The fee is 3% of every $100 and when i put it in. It takes the total amount and just subtracts 3%. Say the load amount is $950, It would need to take 3% of every $100, which would be 27%. making the total $693.50 (roughly if i did the math correctly)

2 Replies

@triplevitruckingllc 

Perhaps

=A1*(1-INT(A1/100)*3%)

if I understood your logic correctly

@Sergei Baklan 

Thank you very much. I am in the process of relearning how to use this program. 

You time and help are very much appreciated.