It sounds like you need a VLOOKUP function, have a look at
http://www.contextures.com/xlFunctions02.html
--
Thanks,
MarkN


"kristyb" wrote:


I am trying to create a quote sheet.

I have located similar information however it doesn't make sense. I
tried to used nested IF statements but the limit of 7 doesn't work out
very well. Then I tried to explore Macros but I have no idea how those
work. So I really need some help.

Right now I have three things.

Amount of Users - Cost

Based on the amount of users, it produces a cost associated.

1 = 10
2 = 15
3 = 20
4 = 30
5 = 40
6 = 55
7 = 60
8 = 70

..... 40 = XXX and so on.

Prices are fictional however I need it to pull the amount of users and
produce teh cost associated with it.


--
kristyb
------------------------------------------------------------------------
kristyb's Profile: http://www.excelforum.com/member.php...o&userid=37311
View this thread: http://www.excelforum.com/showthread...hreadid=570185