Remember Me?

#1
August 13th 14, 06:14 PM
 Junior Member First recorded activity by ExcelBanter: Aug 2014 Posts: 1
If/Then functions

I have a vert. column of cells with values from 1/8, 9/64, 5/32, etc up to 1/2. What I need is to show "if the value in cell E8 is between the values in A12:A15 then show 1/16 in the target cell, if E8 is between A16:A19 show 5/64, if E8 is between A20:A24 show 3/32 and so on... I have tried different combinations of "IF's" and tried a few suggestions from google/yahoo but can't get it right.
I would appreciate any help.
Thanks,
Grim
Attached Images

#2
August 16th 14, 11:33 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2010 Posts: 1,045
If/Then functions

On Wed, 13 Aug 2014 18:14:03 +0100, Grimsgrin wrote:

I have a vert. column of cells with values from 1/8, 9/64, 5/32, etc up
to 1/2. What I need is to show "if the value in cell E8 is between the
values in A12:A15 then show 1/16 in the target cell, if E8 is between
A16:A19 show 5/64, if E8 is between A20:A24 show 3/32 and so on... I
have tried different combinations of "IF's" and tried a few suggestions
from google/yahoo but can't get it right.
I would appreciate any help.
Thanks,
Grim

+-------------------------------------------------------------------+
|Filename: Example1.jpg |
+-------------------------------------------------------------------+

Your jpg is of insufficient resolution for me to tell anything about how your data is set up. But it sounds like you need either a lookup table, or a rounding formula, depending on the mathematical relationship (or lack thereof), between the valule in E8, and the values in column A

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Subodh Excel Programming 1 May 21st 10 02:24 AM Adnan Excel Discussion (Misc queries) 1 October 1st 08 08:30 PM nickname Excel Discussion (Misc queries) 2 July 14th 06 04:26 AM sujay Excel Programming 0 June 5th 06 10:13 AM Kanan Excel Programming 4 May 20th 04 11:21 PM

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