Excell Formula help

[Jimog01]

I need to set up a formula that says:

A3 needs to be 30% of A2 unless B4 is less than 30% of A2, Then A3 needs to
be = to but not more than B4

 

[Liliana]

Try
=IF(B4<A2*0.3,B4,A2*0.3)

 

[JoeU2004]

I need to set up a formula that says:
A3 needs to be 30% of A2 unless B4 is less than 30% of A2,
Then A3 needs to be = to but not more than B4

=min(B4,A2*30%)