I'd recommend against using a function in that way. It means a programmer is required every time and item is added, a price changes or a tax rate
changes. Why not use a lookup instead?
"reneabesmer" <reneabesmer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BB5FEE32-7858-44D5-99F6-71F84F9DD743@xxxxxxxxxxxxxxxx > Hi .... i have a problem that how i can call a function in Excel VBA the
> problem is.
>
> public function price(item)
>
> if(item = "apple") then
> price =10
> tax=0.2
> elseif(item="orange") then
> price =8
> tax=0.5
> end if
> end function
>
> But now how to get the exact tax number of apple which is 0.2
> thanks in advance
>
>
>
>
>
Re: Asset Depreciation question ... I.e., each participant instantaneously adjusts his price charged, his prices paid, and his profit expectation to permit ... government's spending policies are such that the tax revenues are spent, ... So, in the first case, you impose an income tax on each ...retailer (or on the consumer if you want, but since it's the retailer who ... (misc.taxes)
Re: Asset Depreciation question ... his price charged, his prices paid, and his profit expectation to permit ... government's spending policies are such that the tax revenues are spent, ... So, in the first case, you impose an income tax on each ...retailer (or on the consumer if you want, but since it's the retailer who ... (misc.taxes)
Re: F**K! ... that is the price you will have to pay. ... The tax isn't in lieu of that you know, ... provide services free that you would have to pay for otherwise. ... so much for that that saving completely offsets your high gas tax?... (rec.motorcycles)
Re: Fairtax: how does this math work out? ... portion of the final retail price that constitutes the amount the retailer ... have an income tax or a sales tax under the assumption given above. ... (misc.taxes)
Re: Help me please regarding property tax ... impose the tax, or the domestic small aircraft and yacht manufacturers ...yacht building industry has still not yet recovered. ... So if all personal and corporate income taxes only amount to 5% of the price of all goods and services sold in the US, then either your saying that the other 25% of the estimated 30% RST is from other sources, or your math is terrible, or the RST will be radically lower than currently estimated. ... (misc.taxes)
