A simple code:
Round((If(buy it now price < caseif, buy it now price, caseif) * group sale) – ((group sale – 1) * buy it now profit),0)
A complex code:
If(sell type = "nbf auction",auction price & f5 & v6 insurance & match::Auction 1 & f3 & match::Auction 2 & "thanks for bidding" & match::Auction 3 & f7 & match::Auction 3a & f5 & match::Auction 4 & four code workon Clone::description & " " &"” & “$” & ship & “” & match::Auction 5 & payment policy 5 & match::Auction 6 &” ” & v6insert notes 2::description & ” “& ” ” &”” & v6 insurance & ““&” ” & v61insert notes 3::description & “
” & supplier list::Ship to &match::Auction 7 & match::V6 48 & match::Auction 8 & refund policy 14 &”
” & ““& match::Auction 9 & f2 & supplier & match::supplierid & match::Auction 10 ,If(sell type = “doba auction”,auction price & f5 & v6 insurance & match::Auction 1 & f3 & match::Auction 2 & “thanks for bidding” & match::Auction 3 & f7 & match::Auction 3a & f5 & match::Auction 4 & four code workon Clone::description & ” ” &”” & “$” & ship & “” & match::Auction 5 & payment policy 5 & match::Auction 6 &” ” & v6insert notes 2::description & ” “& ” ” &”” & v6 insurance & ““&” ” & v61insert notes 3::description & “
” & supplier list::Ship to &match::Auction 7 & match::V6 48 & match::Auction 8 & refund policy 14 &”
” & ““& match::Auction 9 & f2 & supplier & match::supplierid & match::Auction 10,If(sell type = “postage included A”,auction price & f5 & v6 insurance & match::Auction 1 & f3 & match::Auction 2 & “thanks for bidding” & match::Auction 3 & f7 & match::Auction 3a & f5 & match::Auction 4 & four code workon Clone::description & ” ” &”” & “$” & ship & “” & match::Auction 5 & payment policy 5 & match::Auction 6 &” ” & v6insert notes 2::description & ” “& ” ” &”” & v6 insurance & ““&” ” & v61insert notes 3::description & “
” & supplier list::Ship to &match::Auction 7 & match::V6 48 & match::Auction 8 & refund policy 14 &”
” & ““& match::Auction 9 & f2 & supplier & match::supplierid & match::Auction 10,If(sell type = “doba fixed” and listing type = “Bedding”,buy it now price &”-” & f5 & “-” & v6 insurance & match::ug yellow 1 & f3 & match::ug2 &match::ug2b & “thanks for visiting my store” & match::ug3 & f7 & match::ug3a & f5 & match::ug4 & four code workon Clone::description & ” ” &”” & “$” & ship & “” & match::ug5 & payment policy 5 & match::ug6 &” ” & v6insert notes 2::description & ” “& ” ” &”” & v6 insurance & ““&” ” & v61insert notes 3::description & “
” & supplier list::Ship to &match::ug7 & match::V6 48 & match::ug8 & refund policy 14 &”
” & ““& match::ug9 & f2 & supplier & match::supplierid & match::ug10,If(listing type = “garden” or “coffee” or “cutting board,table service” or “Patio” or “woodworking kits” or “woodworking supplies”, buy it now price &”-” & f5 & “-” & v6 insurance & match::ug border 1a & Backgrounds 2::html& match::ug border 1 & f3 & match::ug2 &match::ug2b & “buy this now for only”” “”$” & buy it now price & ” ” & “Total with shipping is” & ” ” & sell price ship & match::ug3 & f7 & match::ug3a & f5 & match::ug4 & four code workon Clone::description & ” ” &”” & “$” & ship & “” & match::ug5 & payment policy 5 & match::ug6 &” ” & v6insert notes 2::description & ” “& ” ” &”” & v6 insurance & ““&” ” & v61insert notes 3::description & “
” & supplier list::Ship to &match::ug7 & match::V6 48 & match::ug8 & refund policy 14 &”
” & ““& match::ug9 & f2 & supplier & match::supplierid & match::ug10, “left off”)))))
zBlog a perspective 