| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New a little help
I have a number in B4 which will be 1 thru 100 (percentage) I have columns set below and depending on the percentage need to pickup that percentage. If B4 = 20% and F13 is the 15-20% column then F14 needs to contain the number in B5. Make sense?? How can I accomplish this? F14 needs some kind of formula that say if B4 is greater than 15% but less than 20% then equal B5 else nothing. ?? Thanks -- maximus73 ------------------------------------------------------------------------ maximus73's Profile: http://www.excelforum.com/member.php...o&userid=25877 View this thread: http://www.excelforum.com/showthread...hreadid=499968 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
New a little help
worked like a champ! thanks! -- maximus73 ------------------------------------------------------------------------ maximus73's Profile: http://www.excelforum.com/member.php...o&userid=25877 View this thread: http://www.excelforum.com/showthread...hreadid=499968 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
New a little help
You're Very welcome - thnks for the feedback
-- HTH Sandy with @tiscali.co.uk "maximus73" wrote in message ... worked like a champ! thanks! -- maximus73 ------------------------------------------------------------------------ maximus73's Profile: http://www.excelforum.com/member.php...o&userid=25877 View this thread: http://www.excelforum.com/showthread...hreadid=499968 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
