adding a ROUND into an IF Statement
adding a ROUND into an IF Statement
(OP)
I am using an IF Statement to work out the cost of something... by doing this, it will work it out to umpteen decimal places (this messes up the spreadsheet to no end) and not the two decimal places required!
Is there a way of adding a ROUND into the equation to get the two decimal places required?
Is there a way of adding a ROUND into the equation to get the two decimal places required?





RE: adding a ROUND into an IF Statement
RE: adding a ROUND into an IF Statement
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: adding a ROUND into an IF Statement
But yes, why don't you just format the cell to have two decimal points?
On the other hand, if you need intermediate values also rounded (as if someone were writing them all down with two decimal points and then plugging them into a calculator), and can't afford the possibility that your result might be off from that result by a penny, then stick in a ROUND anywhere you need it. I don't see the problem either.
Hg
Eng-Tips policies: FAQ731-376: Eng-Tips.com Forum Policies
RE: adding a ROUND into an IF Statement
=IF(29.99>=G21,G21*(5.25/100),IF(599.99>=G21,(((G21-29.99)*(3.25/100))+1.57),(((G21-99.99)*(1.75/100))+(1.57+18.53))))
I have formated the cell to 'currency', but another formuala in another cell uses the answer... the answer is not to two decimal places, only two decimal places are shown.
Hope this expands on the issue I have.
RE: adding a ROUND into an IF Statement
=ROUND(IF(29.99>=G21,G21*(5.25/100),IF(599.99>=G21,(((G21-29.99)*(3.25/100))+1.57),(((G21-99.99)*(1.75/100))+(1.57+18.53)))),2)
do what you want?
-handleman, CSWP (The new, easy test)
RE: adding a ROUND into an IF Statement
Thanks
RE: adding a ROUND into an IF Statement
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: adding a ROUND into an IF Statement
another hidden command deep within Excel.
RE: adding a ROUND into an IF Statement
TTFN
FAQ731-376: Eng-Tips.com Forum Policies