Creating function in Excel 2010

**JohnnyWalker** · 05-30-2012, 03:08 PM

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

**Richard Buttrey** · 05-30-2012, 03:13 PM

Hi,

One way

=IF(A1<1000,0,(A1-1000)*0.29)

**ben_hensel** · 05-30-2012, 03:19 PM

Welcome to the forum!

So, I'm going to point out that I thought this question was going to be about user defined functions, when instead this is more about, which is logic-dependent algebra.

Okay.
A1: the cell with the number
B1: the cell with the output function

B1 = IF(A1 < 1000, 0, (A1 - 1000) * 0.29)

Note that this throws 0 for A1 = 1000 whether it's LESS THAN as well as LESS THAN OR EQUAL TO, because of the algebra; so it doesn't matter in this case which we use, but I did not from the OP understand which way the logic was supposed to take it.

**JohnnyWalker** · 05-30-2012, 05:13 PM

Hi again!

Thank you two really much. THis answered my question, and I managed. I will probably use this forum next time I'm wondering about something (new job where Excel is a big part of the day, so it is very useful with this)