Forum Discussion
Solved
Excel Formula Help
Hey everyone, I am looking for a fix to my formula. Its probably something simple that I am just not seeing but in the attached sheet in Column K I have a formula. It is working with the exception ...
In K11:
=IF(J11="","",IF(J11<=730,"Treatment Needed",IF(J11<=1460,"Treatment Upcoming","No Treatment Needed")))
Hi Hans, I am getting a #VALUE! error when I plug that in K11
Here is your workbook with the proposed formula.
Thank you Hans! It worked. I tried it again this morning and it worked. Not sure what I did yesterday to it but it works fine today. Thank you for your help!!
Thank you Hans! It worked this morning! Not sure what I was doing yesterday but plugged that in today and it worked just fine.
