I am trying to set-up an IF statement where if the one field is equal to N/A, a days360 function will use one field, and if it is not N/A, then it will use another. Below is an example, and my formula that isn't working...what am I doing wrong? Thank You!!!
Date Entered (C8) = 4/18/2011
Date Deployed (I8) = N/A
Date Closed (K8) = 12/7/2011
=IF(I8=N/A,(days360,C8,K8),(days360,C8,I8))
Does this work?
=IF(I8=N/A,days360(C8,K8),days360(C8,I8))
If I've been of help, please hit the star
=if(i8="n/a",days360(c8,k8),days360(c8,i8))
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
Thank you, but no, it didn't...I am getting the #NAME? error; (same as before)
Could you post a dummy workbook so we can see what's going on?
I will absolutely post a dummy workbook, but not to sound naive, would I just be copying and pasting into the thread, or is there something specific that should be done? (I am totally new to this site, and posting questions such as this on a forum). Thank You!
Click on the "Go Advanced" button below the reply box. From there select manage attachments and navigate to the file. Should be self explanatory from there.
If the workbook is particularly large it wont let you, so you may have to create a dummy book containing the minimal content to allow it to work still.
Thanks Spencer101; got there, then got blocked due to company security. I will have to upload a sample file tonight from home. I think it has to do with the N/A...although I have tried setting it to " " and blanking out the cell...but that didn't work either. I can manipulate the spreadsheet contents anyway needed to make this work if you have any suggestions...thanks!!
The N/A in cell I8, is that a text N/A or the result of a formula (#N/A!) ??
I think if you have the "N/A" in quotes in the formula as per my example it will work
Russell; I did try putting it in quotes, with the formula provided, and it still didn't work. I also tried entering other data into the field, (with and without quotes), and couldn't get it to work...it's driving me crazy because I'm sure it is something so simple..
I figured it out!!! The formula just didn't like N/A, so I changed the field to NA, and it works!!! Thank you both so much for your help with this!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks