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")))
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!!
This link points you to several different possible causes (and associated solutions) for the #VALUE error.
Thanks for the reference Sir but still can't figure out why I'm getting the VALUE error
