IF formula problem

[muphasta]

I am trying to create an "IF" statement but am having difficulty.

Column "C" will be prices of items our project will be purchasing.
Column "D" will be "C" multiplied by 4.1% with a cap of $6150.
I tried:
=IF(C2>150000,"6150", C2<=150000,"C2*0.041")
($150000 being the price where the cap hits)

I get a message stating that I've created too many arguments.

Any help is appreciated.

[Ace_XL]

Try..

=min(C2*0.041,6150)

[Jakobshavn]

=if(c2>150000,6150, c2*0.041)

[Moo the Dog]

Try this in column D:

=MIN(c2*0.041,6150)

- Moo

* Ace_XL got it - he is a quick one.

[muphasta]

Got it!

Thank you very much!

[TheExcelphile]

Hi muphasta!

You don't need the third argument (C2<=150000) in your formula. You also don't need the quotation marks.

Your formula should be:
=IF(C2>150000,6150,C2*0.041)

If you want to read more about IF formula, go here.

Don't forget to click on the little star to the left of this post if you feel I helped!