Can you do complex formulas in the UDF's? I keep a separate MS Excel workbook to track some data & I want to try & calculate that data within SM. Here is a sample from my workbook https://docs.google....dit?usp=sharing I like to see what percentage of SCV I paid for items & also calculate auction starting price at 40% of SCV. Lets say I bought 10 stamps from EBay for $10 total, (I could just say I paid $1 each, but that doesn't show me any good deals, whereas the % of SCV paid will), first I put the total paid in cell G2 (I was thinking UDF #1 in SM for this), then I fill in Scott #'s & SCV in col A & B. the workbook totals the B col & sticks it in G1. Col C auto-populates using " SCV / Col B SUM " ( Cell B# / G1 ) Col D auto-populates using " % of SCV * Total Paid " ( Cell C# * G2 ) Col E auto-populates using ( B# - ( B# * 40% )) More or less I just want to know if (& how) to assign a manual total of an invoice to UDF #1 & see UDF #2 populate the % of SCV Paid & UDF #3 show the 40% of SCV I use for Auction prices. I hope all this makes sense, I don't really understand the math, my father-in-law showed me the formula & he has been using it for 20-25 years now.
Frask got a reaction from admin in UDF's & Math Formulas
