IF conditional formatting

  • Thread starter Thread starter kunal
  • Start date Start date
K

kunal

I have been trying a comparatively simple conditional statement to no
avail and was wonddering if anyone could shed some light.

I need this basic statment

=if(A1 between E1 and F1, D1, "")

A1 to infinity contains a date and if it lies within the date range
contained in each row of E to F it needs to pick up its corresponding
cell value in D1 (also a date function)


Any ideas?
 
Kunal,

=IF(AND(A1>E1,A1<F1),D1,"") ?

I'm not sure because I don't understand what you mean by "the range
contained in each row of E to F"

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
=IF(AND(E1<=A1, A1<=F1),D1,"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
How can I implement this:

=IF(AND(A1>=D1:D4,A1<=E1:E4),C1:C4,"")

what i want to do is compare the Value in A1 with that in a table
stretching from D1 to E20.
If the value in A1 falls inbetween the values of any row of D1-E20,
then we should take the corresponding value in the C column.
So if A1 happens to be between the values in D2:E2 the value we need
picked up is C2, likewise if A1 is between D19:E19 then C:19 is
displayed.

Is there a way i can implement this?


Thanks a lot for helping out!!!
 
Hi Kunal,
I 'm not clear on your question but I think will find your answer in
http://www.mvps.org/dmcritchie/excel/vlookup.htm

Take a look at the gradebook example, which is the first
example on the page.


I don't think your question has anything to do with Conditional Formatting.
Conditional Formatting is used to provide
font type and/or font color and/or interior color, and/or border size/color,
and/or interior pattern (crosshatch, stipulated, lines within cell)
C.F. cannot be use to pull in the value from another cell, nor can it
change the number format of a cell.
http://www.mvps.org/dmcritchie/excel/condfmt.htm
i
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top