ExcelBanter - formulas

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formulas (https://www.excelbanter.com/excel-worksheet-functions/161233-formulas.html)

Ron

formulas

I'm having difficulties getting a formula to work. Any help is appreciated.
Column H2 is a percentage of the previous, If H2 is greater than 40 I need
to multiply by 4%, but if it is greater than 30 mutilply by 3% all other to
equal 0.

daddylonglegs

formulas

You say H2 is a percentage so you mean greater than 40%?

What do you want to multiply by 3% or 4%?, assuming G2 perhaps try

=IF(H2=0.4,4%,IF(H2=0.3,3%,0%))*G2

"ron" wrote:

I'm having difficulties getting a formula to work. Any help is appreciated.
Column H2 is a percentage of the previous, If H2 is greater than 40 I need
to multiply by 4%, but if it is greater than 30 mutilply by 3% all other to
equal 0.

Mike

formulas

Not sure what cell your wanting to multiply I did H2
=IF(H240,H2*4%,IF(H230,H2*3%,0))

"ron" wrote:

I'm having difficulties getting a formula to work. Any help is appreciated.
Column H2 is a percentage of the previous, If H2 is greater than 40 I need
to multiply by 4%, but if it is greater than 30 mutilply by 3% all other to
equal 0.

All times are GMT +1. The time now is 02:12 PM.