Calculations

[triplevitruckingllc]

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]

@triplevitruckingllc 

Perhaps

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

if I understood your logic correctly

[#3]

@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.