Hi there,
I attempted looking in other areas for the info I need, but have been unsuccessful. I am attempting to create a price calculator for my editing business. What I want to be able to do is enter in the Word count, as well as the number of pages. These two items will directly affect the price. So, if Cell B1 (Word Count) is up to 50k then the price is .006 per word. If it is up to 80k then the price is .0065. Anything over 80k then the price is .007. In addition, there will be a fee based on page numbers. The page number price is much easier at a simple .10 per page.
As if that didn't seem complicated enough, there will be four different "types" of edits. The prices by word count above reflect the price on "contextual" editing. There will be 2 other versions- Copy editing and then Proofreading which will have different prices.
Copy- .005, .0055, .006
Proof- .0035, .004, .005
Anyone know how to make this work? Do I need to use a vlookup function?
Bookmarks