If Function

[ajj1971]

Hi all i am tring to return the value of "1" base on a certain value in another cell the problem is the result is based on th returned value being < = or=> ie cell c12 shows a value 50 and value in cell d15=50 and cell e15= 65
so what i would like to do is shown a value of "1" in A18 if c12's value is >=d15(50) <=e15(65)
these figures will vary every time I use it can not be fixed figure so d15 and e15 will change

also need to use if for alomost the same but base on another critria ie. c12 is the same the value must be "1" if < another value in h15

can anyone help

 

[JackDanIce]

Try:

=IF(AND(C12>=D15,C12<=E15),1,0)

 

[BobUmlas]

In A18:
=IF(AND(C12>=D15,C12<=E15),1,"")

 

[MrKowz]

Welcome to the forums!

Try:

<TABLE style="BORDER-RIGHT: black 2px solid; PADDING-RIGHT: 0.4em; BORDER-TOP: black 2px solid; PADDING-LEFT: 0.4em; PADDING-BOTTOM: 0.4em; BORDER-LEFT: black 2px solid; PADDING-TOP: 0.4em; BORDER-BOTTOM: black 2px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff" cellPadding=2 rules=all width="85%"><TBODY><TR><TD style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px; PADDING-BOTTOM: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-RIGHT: #a6aab6 1px solid; BORDER-TOP: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BORDER-BOTTOM: #a6aab6 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" cellPadding=2 rules=all width="100%"><THEAD><TR style="COLOR: #161120; BACKGROUND-COLOR: #e0e0f0"><TH width=10>Cell</TH><TH style="PADDING-LEFT: 5px; TEXT-ALIGN: left">Formula</TH></TR></THEAD><TBODY><TR><TH style="COLOR: #161120; BACKGROUND-COLOR: #e0e0f0" width=10>A18</TH><TD style="TEXT-ALIGN: left">=IF(AND(C12>=D15,C12<=E15),1,"") </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

 

[T. Valko]

Hi all i am tring to return the value of "1" base on a certain value in another cell the problem is the result is based on th returned value being < = or=> ie cell c12 shows a value 50 and value in cell d15=50 and cell e15= 65
so what i would like to do is shown a value of "1" in A18 if c12's value is >=d15(50) <=e15(65)
these figures will vary every time I use it can not be fixed figure so d15 and e15 will change

also need to use if for alomost the same but base on another critria ie. c12 is the same the value must be "1" if < another value in h15

can anyone help

Here's another one...

=IF(C12=MEDIAN(C12,D15:E15),1,"")