Need a little more help

[agoodson1956]

I have this formula
<d2,"in darkness",="" if(h8="D2,"Under" light",="" if(and(h8=""><f2),"under light",="" if(h8=""><d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8="">
<d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""><d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""> = =IF(H8<D2,"In Darkness",IF(H8=D2,"Under Light",IF(AND(H8>D2,H8<F2),"Under Light",IF(H8>F2,"Harvest",IF(H8=F2,"Harvest")))))

I need to add 1 thing. If H8 is blank I don't want it to say anything?</f2),"under></d2,"in></f2),"under></d2,"in></f2),"under></d2,"in></f2),"under></d2,"in>

 

[Joe4]

Your formula is not valid. I beleive it got messed up.
If you are using < or > signs in your formula, please put spaces around either side of them. Otherwise, they get intrepretted as HTML code, messing up the formula.

 

[Joe4]

Re-posted here: https://www.mrexcel.com/forum/excel-questions/1111747-cant-make-work.html#post5352795

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).