Hi Karl

This formula should do it:

=IF(A1=0,0,IF(A1<=500,3,ROUNDUP((A1-500)/500,0)*1.5+3))

Best regards,
Per

"Karl" skrev i meddelelsen
...
Hi,

I work for a publishing company and Im designing a spreadsheet for our
clients. The idea is that the client specifies a few variables and the
spreadsheet will tell them how much the project will cost and how long it
will take.

One of things I want to do is have them enter the word count of the
article
they want written. In another cell, I want to put a formula that will
check
the word count and calculate the following using nested IF statements
(assuming thats the best way to do it):

€¢ If the word count is zero then populate this cell with the value €˜0
€¢ If the word count is more than zero, for the first 500 words populate
the
cell with the number €˜3, for every subsequent 500 words add the number
€˜1.5
to the initial €˜3.

So if the wordcount 1000 is entered into A1 and the formula is in B1, the
value in B1 would be 4.5. The value in B1 represents the number of hours
it
will take to write the article.

Is this possible? If it is, can anyone help me with the formula?

Many thanks

Karl