Posted to microsoft.public.excel.worksheet.functions
|
|
Conditional Formula
Sorry about not mentioning the "No" as I know how to install.
But for the Rest of the story, IT WORKED!
Thanks Ragdyer!
And thanks to all who participated!
Happy Holidays to all!
Jon
"Ragdyer" wrote:
You never mentioned "NO" in your earlier posts.
Does this work for you:
=IF(OR(AND(J70,J7<J8),J8J6),"YES","NO")
?
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jon" wrote in message
...
Sure will--Thanks!
J5 is 120
J6 is 193.3
J7 is 0
J8 is 149.0
I am looking to see if J8J7, but on the conditional if J7=O or blank (I
could set up either way) than the formula refer to J8J6 reuturning a
result
of "Yes" if it is greater "No" if it is not.
Example:
K6 Should read Yes (due to refering to J6J5)
K8 should read No (due to refering to J8J6)
Hope this is enough information
"Ragdyer" wrote:
How about posting exactly what *is* in J6 & J7 & J8,
And what *might* be in each of them.
Keyed in data - What kind - text, or numbers, give examples -
Formulas - do they return text, or numbers, or nulls ( "" - zero length
strings), or logicals (True, False), or error values (#N/A!) - post the
formulas -
Imported data - possibly containing invisible characters -
The more information you give concerning the contents of the cells in
question will enable you to receive more viable suggested solutions.
--
Regards,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"Jon" wrote in message
...
SteveG,
I copied and pasted it still it showing a Yes when it should not.
I really appreciate the help with all this from all three of you!
Any more suggestion?
Jon
"SteveG" wrote:
Does this work?
=IF(AND(ISBLANK(J7),J8J6),"Yes",IF(J8J7,"Yes","" ))
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=495474
|