I'm trying to make a formula. For example

If the value is Greater then 500,000 I need it to multiply the amount by 10% then add 1,200 (expample: 500,000 X 10% + 1200)

If the value is less then 500,000 I just want it to add 1700
(example: 400,000 + 1700)

I just need excel to know what to do if the value is greater/less then 500,000

Much appreciated thanx
Jason

 

maybe not..

 

Try pressing F1.

 

Set a cell to be your treshold value (you don't have to, but it makes your spreadsheet a little easier to maintain), say:
A1=500000

Lets say the value you're testing is in B1:
=IF(B1>$A$1,B1*0.1+1200,B1+1700)

The function is:
IF([condition],[value_if_true],[value_if_false])

 

BTW, do you mean add 10% (i.e., multiply by 110%)? That seems to make more sense to me, but I guess I don't really know your application.

 

Thanks, got it bud