LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default Value part of formula exlusion/ Not affects neg's: value

060509 Value part of formula exlusion/ Not affects neg's: value

don't know if can explain, else would be able to figure out myself?

making logical? filters if different column has (x1 23 or y 123 positions)
filter INTO this equation, am using: (absolute/fixed cell: "filter" enter
any of x y 1 2 3, x1 x2..)
PROBLEM: value(right( fixed if right = a number,
now if S9 empty, get Value error: S9="" didn't fix.
(1 step away, other filters work in conjunction, as listed at bottom).
thanks..

=IF(OR...AND((S9="",$AH$5<"",$AH$5<S9,$AH$5<LEF T(S9,1),$AH$5<VALUE(RIGHT(S9,1))),"", ...

exact equation is:
=IF(OR(AJ9="",AND(EXACT($AH$4,"H"),J9<"h",M9<"h" ),
AND(EXACT($AH$4,"h"),L9<"h",O9<"h"),
AND($AH$4="x",K9<"x",N9<"x"),
AND(S9="",$AH$5<"",$AH$5<S9,$AH$5<LEFT(S9,1),$A H$5<VALUE(RIGHT(S9,1))),AND($AH$7<"x",CZ9="T")), "",
IF(AND($AH$2="u",CY9="u"),"u",IF(AND($AH$2="d",CY9 ="d"),"d","")))
 
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
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
2 Nesting questions Starchaser Excel Worksheet Functions 7 January 20th 06 06:53 PM
Getting Excel whilst using the sumif formula to search for part of a word Newbie81 Excel Discussion (Misc queries) 1 December 20th 05 01:56 PM
What instead of an array formula part 2 Reg Besseling Excel Discussion (Misc queries) 2 December 10th 04 07:35 AM
Formula for Extracting Alphabetic Part of a Product Code ob3ron02 Excel Worksheet Functions 5 October 30th 04 12:35 PM


All times are GMT +1. The time now is 05:13 PM.

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

About Us

"It's about Microsoft Excel"