In short, no.

You should be able to get a solution with VLOOKUP, or another lookup
function. If you post more specific information about you sheet layout,
someone here can help you.
Or, you can search this group for VLOOKUP. Or, you can try some websites.
Here is one to get you started:
http://www.contextures.com/xlFunctions02.html

--
tj


"Liv4fun" wrote:


I am trying to create a proposal form that based on the number of users
the form changes prices.

I have a cell for number of users and then have a list of prices based
upon the number of users. So if they say 4 users it takes the base
price and ads the price for the 4 users. My problem is I can only say
"IF" 7 times thus I can only price 1-7 users and I need to get to a
point where it is 10 or more users. Is there another way other than
using the IF statement?

I hope this makes sense!


--
Liv4fun
------------------------------------------------------------------------
Liv4fun's Profile: http://www.excelforum.com/member.php...o&userid=28858
View this thread: http://www.excelforum.com/showthread...hreadid=486092