Hi,
I have a question I hope you can help me with.
I want a function to work like this:
When a number in one cell is less then 1000 it should return in another 0. When it pass 1000 (for example 1200) it should return (1200-1000)*0,29 = 58
If the number in the cell is 2000 it should return (2000-1000) * 0.29 = 290
BUT, is it for example 900 (less than 1000) it should be 0.
Hope this explaination wasn't to bad - if you need any further information - please ask
Kind Regards
JohnnyWalker
Bookmarks