formulas

[ron]

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]

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

 

[Mike]

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