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?
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?