Can't make it work?

agoodson1956

Board Regular
Joined
Sep 1, 2016
Messages
140
I need one more thing

<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")))))
<d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8="">
If H8 is blank I want it to say nothing</f2),"under></d2,"in></f2),"under></d2,"in></f2),"under></d2,"in>
 
Last edited by a moderator:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,476
Office Version
365
Platform
Windows
How about
=IF(H8="","",IF(H8< D2,"In Darkness",IF(H8=D2,"Under Light",IF(AND(H8 >D2,H8< F2),"Under Light",IF(H8 >=F2,"Harvest")))))
 

Forum statistics

Threads
1,078,365
Messages
5,339,765
Members
399,323
Latest member
letitiaysk

Some videos you may like

This Week's Hot Topics

Top