formula from a date in a different cell

[j4ymf]

Hello I'm trying to create a work sheet but im stuck on the formula


im trying to get my value from H10 which = 2
my cell my formula goes in is I10
my date is in I7
End date is in F10

can I create a formula thats in I10 that looks at a date in I7 and if its less than the date in F10 places a value from H10

hope this makes sense

thank you Jason

 

[j4ymf]

can it be something like
=if(I6<F10),"H10"

 

[Joe4]

It doesn't look like your formula is coming though. Probably because of this here: https://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html

To be honest, I found your explanation a bit confusing. If might be better to walk us through an actual example (with actual data and cell references, along with your expected results of that example).

 

[Fluff]

Maybe
=if(I7< F10, H10,"")

 

[j4ymf]

Thank you joe4 for your reply

=if(J6 > F10 < G10) = the value of I10

does that make more sense

jay

 

[Joe4]

If you want to check for two conditions like that, you need to use AND, i.e.

=IF(AND(J6 > F10, F10 < G10),I10,"")

 

[j4ymf]

=IF(J6>F10<G10,I10,"") I get nothing. im want my answer to be the value of I10

=IF(J6>F10<G10=I10,"") I get false

getting there, thank you for your help so far

 

[j4ymf]

=IF(AND(J6 > F10, F10 < G10),I10,"") gives me a blank and should be a 2

 

[Fluff]

What are the values in J6, F10 & G10?

 

[Joe4]

=IF(AND(J6 > F10, F10 < G10),I10,"") gives me a blank and should be a 2

Please tell us the values in cell J6, F10, G10 and I10 in your example.