Def a confusing title, but basically I've got a column that is calculating days between two dates. I'm looking for an IF function that will render negative cells to "N/A" and error cells to "Evergreen". I was easily able to use an IFERROR function to render the blanks, but I do not know how to change negative numbers nor how to combine with an IFERROR function.
Any help is greatly appreciated. Thanks
if(iserror(value),"evergreen",if(value<0,#N/A,value))
you could use something like =IF(cell<0,"N/A"... but it might be easier to see what the formula is you are using and what you want as the output. Even a small sample file would be helpful.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
If you find yourself that the title is confusing, why don't you attach a file? You would most probably already have gotten the answer...Originally Posted by templeowls
I cannot post a sample file or else I would have. Anytime I press the attachment button, I get small narrow, empty rectangle. Not quite sure what that is about; maybe too new of a user?
Anyway I'm using the following formula to calculate the days between dates:
B1 is the date, minus Today. As I stated above, I'm already able to show errors as "Evergreen", just not sure how to show negative days as "N/A" as well
Please Login or Register to view this content.
Click the " Go advanced " button - Manage attachments and follow the wizard. Forgot to mention the paperclip icon is OOO
Try
=IF(TODAY>B1,NA,IFERROR(B1-TODAY(),"Evergreen"))
Sweet thanks, see attached. The formula you sent doesn't seem to be working for me. Getting a #NAME error
are you saying you want the output of a positive number to be the word evergreen and the output to be N/A if it is a negative number OR do you want a number as the output for positive and a N/A for a negative number?
BTW, if you are using Pepe's formula in post #7 you need to add parens to the first TODAY like this... =IF(TODAY()>B1,"NA",IFERROR(B1-TODAY(),"Evergreen"))
AND "" around the N/A.
Last edited by Sam Capricci; 06-26-2019 at 09:51 AM.
That did the trick!! Thanks Sambo and Pepe!!!
You're welcome, and if that takes care of your question don't forget to mark the post as solved using the thread tools dropdown at the top of the post.
and BTW, I got my MBA from Temple University.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks