Excell Formula help
 

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

Excell Formula help
 

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

On Thu, 23 Jul 2009 16:27:01 -0700, Jimog01 wrote:

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

Excell Formula help
 

"Jimog01" wrote:
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%)