LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
aliend
 
Posts: n/a
Default Vlookup help


Hello all. At work, I have just started to use Excel and it has been
some time since I last used it. I'm having a bit of a problem with
vlookup.

I want to use vlookup to display a number value if the cell in question
contains a number that is 10 or below the number. This number will then
be multiplied by a percentage (so I'm presuming I could just put in
somewhere *10/100 to multiply the value by 10 percent?) The percentage
that it is multiplied by varies depending on weather or not the value
is below 10.

I really am stuck here, any help would be greatly appreciate. Even a
good link to a website that could explain what I am trying to do.

Thank you very much and take care


--
aliend
------------------------------------------------------------------------
aliend's Profile: http://www.excelforum.com/member.php...o&userid=25596
View this thread: http://www.excelforum.com/showthread...hreadid=390138

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Have Vlookup return a Value of 0 instead of #N/A Mr Mike Excel Worksheet Functions 4 May 25th 05 04:51 PM
Array Function with VLOOKUP CoRrRan Excel Worksheet Functions 15 April 8th 05 05:54 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 12:09 PM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 10:43 AM
VLOOKUP not working Scott Excel Worksheet Functions 3 November 12th 04 08:06 PM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"