I would like to set up a spreadsheet that I can import into a Word Document. I have searched every where but don't know if it is possible. What I am trying to accomplish is this. Let's say the client has 121 chairs, So the formula should read that anything from 0 - 150 chairs is this rate, 151 - 200 chairs will be this rate, ect. What I want to do is set it up and then just have to input the number of chairs and it will do compute it from there.
Something like
=Lookup(A1,{0,151,201,251},{0,5,10,20})
where A1 is the cell you input number of chairs, and 0, 151, 201, 251 are the lower bounds of the ranges.. and 0, 5,10, 20 are the corresponding rates...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I tried that and it's not multipling. I'm just getting an error message #Name?
Did you type it in correctly?
Can we see your formula?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks