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!!
Thank you Hans! It worked this morning! Not sure what I was doing yesterday but plugged that in today and it worked just fine.
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
Nor can I. I plugged Hans's formula in to your spreadsheet and it worked without an error.
So you could help us help you by describing what solutions, from that link, you tried. It's kind of hard--i.e., next to impossible--for us to figure out what's going wrong without seeing anything going wrong. You're the one with the experience, so unless you can explain further what you're experiencing, what changes you're making (if any).
As noted, it worked when I copied it from his post and plugged it into your spreadsheet. You could also post a copy of the spreadsheet with the #VALUE error. It's possible, I suppose, that you've made a small mistake in the formula that Hans gave you.
