=IF(B3120,(B3-20)*1.08,B3*1.08)


Gord Dibben MS Excel MVP

On 13 Feb 2007 10:21:58 -0800, "Tommy" wrote:

I would like to take a value in a cell (B3) and perform the following
calculation and record in cell (B4)

If B3120, then subtract 20 and multiply the result by 1.08.
If B3<=120 then multiply B3 by 1.08.

Any assistance is appreciated

Thanks!
Tommy