Solved

# Need Help with Excel Formula

Posted on 2013-06-19
312 Views
I want to use the IFERROR function or ISNA function to do the following on my spreadsheet but I cannot seem to get it to work.

I want to check if cells D4=D5
If that is true, I want it to check cells E4=E5.
If that is true, return me the value Buy/Sell Occurred.

How do I do that?
0
Question by:ArisaAnsar
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 23

Accepted Solution

NBVC earned 500 total points
ID: 39260339
Try:

Note:  ISNA or IFERROR isn't required here... the formula will return a null if not true.  You can insert a phrase between the sets of  double quotes if desired
0

Author Closing Comment

ID: 39260358
Thank you so very much.
0

LVL 26

Expert Comment

ID: 39260371
Just a little addition. You can expand on NB_VC's formula to get as creative as you want

For example:

Try various combinations in D4, D5, E4 and E5 to see the results.

I was just needing a distraction from work and thought I would play for a minute.  :)
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month1 day, 15 hours left to enroll