Solved

Need Help with Excel Formula

Posted on 2013-06-19
3
309 Views
Last Modified: 2013-06-19
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
Comment
Question by:ArisaAnsar
3 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39260339
Try:

=IF(D4=D5,IF(E4=E5,"Buy/Sell Occurred",""),"")

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

by:ArisaAnsar
ID: 39260358
Thank you so very much.
0
 
LVL 26

Expert Comment

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

For example:

=IF(D4=D5,IF(E4=E5,"Buy/Sell Occurred","Buy Occurred"),IF(E4=E5,"Sell Occurred","NothinghappenedToday"))

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

785 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