Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default conditional formula needed

it might be possible to do this as a conditional formula (=if) otherwise a
macro might be needed.

the thing i'm unsure about is this formula looks at the cells beneath it and
keeps looking until a result is returned, i'm not sure if that can be done as
a conditional formula.

if you really want to know what this is for send me a pm and i'll tell you.


if m3 = 0 then ""
if l3 = i then ""
if m3 = 1 and if l3 = "c" and if i3 0

and if e4 €“ d3 < -.0066 then result = 1
write result in n3
else go to row 5

if e5 €“ d3 < -.0066 then result = 1

if d5 = d3 then result = 0

i seriously doubt this will happen but in case it does
if e5 €“ d3 < -.0066 and if d5 d3 then result = "ambiguous"
else go to next row
keep going down the rows (it should not take any more than 3 or 4) until
either


if i3 < 0
and if e4 €“ d3 .0066 then result = 1
write result in n3
else go to row 5

if e5 €“ d3 .0066 then result = 1
if d5 < d3 then result = 0

must loop through all the rows, there 8800 of them
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default conditional formula needed

any thoughts on this?

"kylefoley2000" wrote:

it might be possible to do this as a conditional formula (=if) otherwise a
macro might be needed.

the thing i'm unsure about is this formula looks at the cells beneath it and
keeps looking until a result is returned, i'm not sure if that can be done as
a conditional formula.

if you really want to know what this is for send me a pm and i'll tell you.


if m3 = 0 then ""
if l3 = i then ""
if m3 = 1 and if l3 = "c" and if i3 0

and if e4 €“ d3 < -.0066 then result = 1
write result in n3
else go to row 5

if e5 €“ d3 < -.0066 then result = 1

if d5 = d3 then result = 0

i seriously doubt this will happen but in case it does
if e5 €“ d3 < -.0066 and if d5 d3 then result = "ambiguous"
else go to next row
keep going down the rows (it should not take any more than 3 or 4) until
either


if i3 < 0
and if e4 €“ d3 .0066 then result = 1
write result in n3
else go to row 5

if e5 €“ d3 .0066 then result = 1
if d5 < d3 then result = 0

must loop through all the rows, there 8800 of them

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default conditional formula needed

It's hard for anybody to have an idea because your statement of the problem
is long on minute points but short on a concise statement of what you are
trying to do. Help us help you by being clear and concise about what you are
trying to accomplish.


"kylefoley2000" wrote:

any thoughts on this?

"kylefoley2000" wrote:

it might be possible to do this as a conditional formula (=if) otherwise a
macro might be needed.

the thing i'm unsure about is this formula looks at the cells beneath it and
keeps looking until a result is returned, i'm not sure if that can be done as
a conditional formula.

if you really want to know what this is for send me a pm and i'll tell you.


if m3 = 0 then ""
if l3 = i then ""
if m3 = 1 and if l3 = "c" and if i3 0

and if e4 €“ d3 < -.0066 then result = 1
write result in n3
else go to row 5

if e5 €“ d3 < -.0066 then result = 1

if d5 = d3 then result = 0

i seriously doubt this will happen but in case it does
if e5 €“ d3 < -.0066 and if d5 d3 then result = "ambiguous"
else go to next row
keep going down the rows (it should not take any more than 3 or 4) until
either


if i3 < 0
and if e4 €“ d3 .0066 then result = 1
write result in n3
else go to row 5

if e5 €“ d3 .0066 then result = 1
if d5 < d3 then result = 0

must loop through all the rows, there 8800 of them

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Sum Formula needed faureman via OfficeKB.com Excel Discussion (Misc queries) 0 July 9th 09 09:38 PM
formula needed for conditional formatting veena Excel Discussion (Misc queries) 7 July 9th 08 08:47 PM
Another Conditional Formatting Formula needed? Dan the Man[_2_] Excel Worksheet Functions 6 July 23rd 07 10:34 PM
Formula or Conditional Formatting Help needed. SCrowley Excel Worksheet Functions 1 May 14th 07 06:14 PM
Conditional Format Formula Needed PAR Excel Worksheet Functions 11 May 20th 05 08:45 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"