Smart questions
Smart people
 Find A ForumFind An Expert
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Remember Me

Are you a
Computer / IT professional?
Join Tek-Tips now!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Just copy and paste the

#### Feedback

"...One of the best run forums I have used in years! ...I like the way the site is organized and your no tolerance of flames..."

#### Geography

Where in the world do Tek-Tips members come from?

# Formula or IF statement ? Sheet to calculate eBay listing costs

 Forum Search FAQs Links Jobs Whitepapers MVPs
 BigGeoff (Vendor) 10 Apr 12 14:37
 Hi all,I'm fairly new to Excel but would class myself as more capable than a noob.But, I want to look at a range of figures to determine the cost of an item listed in eBay.The eBay costs would be:From:  To:.01      .99       £01         4.99    £.155         14.99  £.2515       29.99   £.530        99.00  £1100 or over     1.30So I want to enter a cost of an item in cell C1 and have the formula/statement return the appropriate eBay cost, referencing the above.Any help greatly appreciated.RegardsGeoff
 SkipVought (Programmer) 10 Apr 12 14:53

hi,

#### Quote:

So I want to enter a cost of an item in cell C1
HOW can THAT be?

You have THREE columns of data posted, the third being column C???

assuming that your table is in a1:c7

then if your value is in D1, rather than C1...

=VLOOKUP(D1,\$A\$2:\$C\$7,3,TRUE)

Skip,

Just traded in my old subtlety...
for a NUANCE!

 BigGeoff (Vendor) 10 Apr 12 15:03
 Cheers for the speedy reply Skip !!Works a treat Geoff

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!