| Home |
| Search |
| Today's 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autocomplete Custom Functions and functions arguments | Excel Programming | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
| excel functions and User defined functions | Excel Programming | |||
Threaded Mode
