Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
roy.okinawa
 
Posts: n/a
Default multiple formulas in one cell

I want to look at data in three cells A,B,C, that result in a answer in cel
D. I have the first part. Example: If Cell A<=Cell B, return "YES","NO" in
cell D

Now what I want it also to do is look in Cell C for a date. If no date is
found, I want cell D to be blank until a date is filled in cell C. Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15
  #2   Report Post  
Biff
 
Posts: n/a
Default multiple formulas in one cell

Hi!

Try this:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1),A1<=B1,ISNUMBER( C1)),"Yes","No")

Biff

"roy.okinawa" wrote in message
...
I want to look at data in three cells A,B,C, that result in a answer in cel
D. I have the first part. Example: If Cell A<=Cell B, return "YES","NO"
in
cell D

Now what I want it also to do is look in Cell C for a date. If no date is
found, I want cell D to be blank until a date is filled in cell C. Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15



  #3   Report Post  
roy.okinawa
 
Posts: n/a
Default multiple formulas in one cell

It still comes back with a YES or NO. If no dates is in C then D is blank.
Current formula in cell:

=IF(AND(ISNUMBER(W163),ISNUMBER(X163),W163<=X163,I SNUMBER(V163)),"Yes","No")

"Biff" wrote:

Hi!

Try this:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1),A1<=B1,ISNUMBER( C1)),"Yes","No")

Biff

"roy.okinawa" wrote in message
...
I want to look at data in three cells A,B,C, that result in a answer in cel
D. I have the first part. Example: If Cell A<=Cell B, return "YES","NO"
in
cell D

Now what I want it also to do is look in Cell C for a date. If no date is
found, I want cell D to be blank until a date is filled in cell C. Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15




  #4   Report Post  
Biff
 
Posts: n/a
Default multiple formulas in one cell

Ooops!

Try this:

=IF(ISNUMBER(V163),IF(AND(ISNUMBER(W163),ISNUMBER( X163),W163<=X163),"Yes","No"),"")

Biff

"roy.okinawa" wrote in message
...
It still comes back with a YES or NO. If no dates is in C then D is
blank.
Current formula in cell:

=IF(AND(ISNUMBER(W163),ISNUMBER(X163),W163<=X163,I SNUMBER(V163)),"Yes","No")

"Biff" wrote:

Hi!

Try this:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1),A1<=B1,ISNUMBER( C1)),"Yes","No")

Biff

"roy.okinawa" wrote in message
...
I want to look at data in three cells A,B,C, that result in a answer in
cel
D. I have the first part. Example: If Cell A<=Cell B, return
"YES","NO"
in
cell D

Now what I want it also to do is look in Cell C for a date. If no date
is
found, I want cell D to be blank until a date is filled in cell C.
Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15






  #5   Report Post  
roy.okinawa
 
Posts: n/a
Default multiple formulas in one cell

That did it.

Thank you.

"Biff" wrote:

Ooops!

Try this:

=IF(ISNUMBER(V163),IF(AND(ISNUMBER(W163),ISNUMBER( X163),W163<=X163),"Yes","No"),"")

Biff

"roy.okinawa" wrote in message
...
It still comes back with a YES or NO. If no dates is in C then D is
blank.
Current formula in cell:

=IF(AND(ISNUMBER(W163),ISNUMBER(X163),W163<=X163,I SNUMBER(V163)),"Yes","No")

"Biff" wrote:

Hi!

Try this:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1),A1<=B1,ISNUMBER( C1)),"Yes","No")

Biff

"roy.okinawa" wrote in message
...
I want to look at data in three cells A,B,C, that result in a answer in
cel
D. I have the first part. Example: If Cell A<=Cell B, return
"YES","NO"
in
cell D

Now what I want it also to do is look in Cell C for a date. If no date
is
found, I want cell D to be blank until a date is filled in cell C.
Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15






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
Formulas within Cell References jhockstr Excel Discussion (Misc queries) 4 August 13th 05 06:40 AM
Problem with formulas changing cell reference janicesweet Excel Discussion (Misc queries) 1 August 2nd 05 06:23 PM
Need Formulas for counting multiple conditions OrdOff Excel Worksheet Functions 4 July 3rd 05 06:12 PM
apply cell names to formulas in multiple worksheets BBurrows Excel Worksheet Functions 4 July 1st 05 05:35 PM
Entering multiple formulas in one cell HP Excel Worksheet Functions 1 May 4th 05 11:06 PM


All times are GMT +1. The time now is 09:21 PM.

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"