software

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: www.excelforum.com/member.php...oamp;userid=25877
View this thread: www.excelforum.com/showthread...hreadid=499968Try:

=IF(AND(B4gt;=15%,B4lt;=20%),B5,quot;quot;)

--
HTH

Sandy
with @tiscali.co.ukquot;maximus73quot; gt; wrote in
message ...
gt;
gt; I have a number in B4 which will be 1 thru 100 (percentage)
gt;
gt; I have columns set below and depending on the percentage need to pickup
gt; that percentage. If B4 = 20% and F13 is the 15-20% column then F14
gt; needs to contain the number in B5. Make sense?? How can I accomplish
gt; this? F14 needs some kind of formula that say if B4 is greater than
gt; 15% but less than 20% then equal B5 else nothing. ??
gt;
gt; Thanks
gt;
gt;
gt; --
gt; maximus73
gt; ------------------------------------------------------------------------
gt; maximus73's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25877
gt; View this thread: www.excelforum.com/showthread...hreadid=499968
gt;

worked like a champ! thanks!--
maximus73
------------------------------------------------------------------------
maximus73's Profile: www.excelforum.com/member.php...oamp;userid=25877
View this thread: www.excelforum.com/showthread...hreadid=499968You're Very welcome - thnks for the feedback

--
HTH

Sandy
with @tiscali.co.ukquot;maximus73quot; gt; wrote
in message ...
gt;
gt; worked like a champ! thanks!
gt;
gt;
gt; --
gt; maximus73
gt; ------------------------------------------------------------------------
gt; maximus73's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25877
gt; View this thread: www.excelforum.com/showthread...hreadid=499968
gt;