Formula Problem (rounding)

[Joe A]

I have the following formula in one file which works great. I want to round the result off to 2 decimals but I can't figure out where to place the (round) command. Normally I'd use "round(deposit,2)" but it doesn't work either at the beginning or end. Thanks

If(Terms = "C.O.D",Total Proposal *.50, If(Terms = "Net 30 with Deposit",Total Proposal*.50, If(Terms ="Open Account with Deposit",Total Proposal*.50,0)))

[SteveB]

Round(Case(Terms = "C.O.D",Total Proposal *.50, Terms = "Net 30 with Deposit",Total Proposal*.50, Terms ="Open Account with Deposit",Total Proposal*.50,0),2)

I find the Case to be easier to work with, and I believe it is more efficient.

Steve