Excel help

[ManBearPig]

How would i calculate something as $2.50 or 5% of the material costs, whichever is greater?

Would it be an if statement?

 

[tw1164]

=If(A1*.05>2.5,A1*.05,2.5)

I think that will work, I can't test it I don't have excel installed at the moment.

 

[ManBearPig]

cool...thanks alot.

so how exactly would you say that?

if a1*.05 is greater than 2.5............? fill in the rest please? 😀

 

[JustAnAverageGuy]

If (MaterialCost * 5% > 2.5)
IfTrue MaterialCost * 5%
IfFalse 2.5

the cell formula itself is
=IF((A1*5% > 2.5), (A1*5%), 2.5)

Where A1 is whatever cell MaterialCost is.

- JaAG

 

[mayest]

The IF statement will work, but it is probably slightly more efficient to use the Max function:

=Max(A1*0.05,2.50)

That way you only have to evaluate the 5% of A1 one time. Not that you will notice the difference.

 

[NeoV]

mayest is correct if this is a formula that you will be using on a lot of rows, it will use less memory

both work though