Excell Formula help

  • Thread starter Thread starter Jimog01
  • Start date Start date
J

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
 
Jimog01 said:
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
Click to expand...

=min(B4,A2*30%)
 
Back
Top