Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Formula
I constructed a lookup table with formula's on the second sheet which I want to use to return a working formula on sheet 1. Example Shape Code 39: Formula (as in the book) A + 0.57 B + C -1.57d Value's A,B and C are user defined and can be found on sheet 1 in the columns M,N and O d= is the diameter and is user defined in column F In my lookup table I have the following formula (sheet 2) INDIRECT("M"&ROW())+0.57*INDIRECT("N"&ROW())+INDIR ECT("O"&ROW())-1.75*INDIRECT("F"&ROW()) What do I need to do to get this cell working on sheet 1 Now it eiter returns the text (when = sign is left out) or returns the result from sheet two Thanks, W -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96571 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if formula return | Excel Discussion (Misc queries) | |||
Return Last Value in a Row formula | Excel Worksheet Functions | |||
No return for formula | Excel Worksheet Functions | |||
Why does my formula return zero? | Excel Discussion (Misc queries) | |||
I need help with way to return 0 or N/A to a formula | New Users to Excel |