LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jay
 
Posts: n/a
Default Function Mal-Functioning

I have this application that does a couple of things. One though, is being a
bit problematic. Can some one who has the answer chime in with corrections?
The problem is this, three columns
1.) Column I3 equal to =IF(ISBLANK(H17),"",IF(H17=4.5,0,$I$2-H17))

2.) Column J3 equal to =IF(ISBLANK(H17),"",IF(H17<=5.5,0,H17-$J$2))

3.) Column K3 equal to
=IF(AND(ISBLANK(I17),ISBLANK(J17)),"",IF(AND(I17=0 ,J17=0),"Pass","Fail"))

The problem is that even if the columns I & J are "" empty (No Value),
column H displays "Fail". What I need is to have no value shown in column "H"
if all columns to the left are "" (I & J are Blank).

Is it possible to correct this painlessly?

Looking forward to your input.

Thanks,
 
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
Need a ISWorkday Function -- Any Ideas Mark Excel Worksheet Functions 5 March 29th 05 01:58 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 03:48 AM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM


All times are GMT +1. The time now is 08:54 AM.

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"