Solved

Excel: IF(ISNA) / Else calculation statement

Posted on 2014-11-03
3
187 Views
Last Modified: 2014-11-03
Hello,

I would like to run a IF(ISNA) statement, however if there is no '#N/A' found, then run a calculation. Is this possible?

My current formula is (line breaks for ease of reading)

=IF(ISNA(I2-(INDEX('Sent Emails'!I:I,MATCH('3 Month Letter'!A2,'Sent Emails'!A:A,0)))),1,
(INDEX('Sent Emails'!I:I,MATCH('3 Month Letter'!A2,'Sent Emails'!A:A,0))))>240,1,2))

Currently, this returns 'false' if there's no #N/A. Instead I would like Excel to calculate the second line of my formula.

Thanks
0
Comment
Question by:dabug80
3 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 250 total points
Comment Utility
I think you are missing an IF at the start of the second line. Otherwise, what you have got would not make sense.
0
 
LVL 31

Assisted Solution

by:Rob Henson
Rob Henson earned 250 total points
Comment Utility
You are getting FALSE because it is calculating the second part of the Formula but you are missing an IF.

The second part of the formula is looking at INDEX(.....) and comparing to 240 but currently all its doing is "Index calc'd Value" > 240  TRUE or FALSE. I believe it should be:

=IF(ISNA(I2-(INDEX('Sent Emails'!I:I,MATCH('3 Month Letter'!A2,'Sent Emails'!A:A,0)))),1,
IF((INDEX('Sent Emails'!I:I,MATCH('3 Month Letter'!A2,'Sent Emails'!A:A,0))))>240,1,2)))

Thanks
Rob H
0
 
LVL 1

Author Closing Comment

by:dabug80
Comment Utility
Thanks. I split the points. Final formula was:

=IF(ISNA(I2-(INDEX('Sent Emails'!I:I,MATCH('3 Month Letter'!A2,'Sent Emails'!A:A,0)))),1,IF((INDEX('Sent Emails'!I:I,MATCH('3 Month Letter'!A2,'Sent Emails'!A:A,0)))>240,1,2))
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now