LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default Trying Again (Burt)

This appears to meet your conditions:
=IF(ISBLANK(X11),IF(AND(H11="x",K11<=14),"Y",IF(AN D(H11="x",K11=15),"N")),IF(AND(X11="x",H11="x",K1 1=15),"C","Y"))

however, if h11 is blank or contains a value other than x, AND x11 is blank
it returns a FALSE
or
if h11 is blank or contains a value other than x, AND x11 is not blank, L11=Y

if you can give me some idea of what you want to do about non-x values in
h11 or x11, I can refine the formula


"Help with cell function" wrote:

Sorry if this offends anyone, but I need an answer and I already submitted
this question yesterday.
the below formula was close, but not quite.
I only want a C to show up in L6 if a N is going to be the answer, if a Y is
the answer then I need to keep the Y. If X6 is not an x then the answer needs
to stay the same in L6

=IF(H6="x", IF(K6<=14,"Y", IF(X6="x","C","N")), "")

 
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
New Formula (Burt) Help with cell function[_2_] Excel Discussion (Misc queries) 9 December 22nd 09 05:40 PM


All times are GMT +1. The time now is 07:14 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"