help making calculation with IF

dquevillon

New member
Joined
Oct 15, 2014
Messages
2
Reaction score
0
Points
0
Hello everyone,

i've been looking for a while now for an answer to this but seems like I cannot express myself good enought to find it by myself on google.

I have a number in cell B1 and I want cell B7 to give me 1500$ if B1 is =< 10 or if B1 > 10 then (((B1-10)*50)+1500) i could not find anything yet that would permit me to do this.

Can anyone help me out with this?
 
Do you mean?

=IF(B1<=10,1500,((B1-10)*50)+1500)
 
Back
Top