ExcelBanter - Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula Help (https://www.excelbanter.com/excel-programming/383155-formula-help.html)

Tommy[_10_]

Formula Help

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

merjet

Formula Help

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

Merjet

Gord Dibben

Formula Help

=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

All times are GMT +1. The time now is 05:24 PM.