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