Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

Need Help with Excel Formula

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
ArisaAnsar
Asked:
ArisaAnsar
1 Solution
 
NBVCCommented:
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
 
ArisaAnsarAuthor Commented:
Thank you so very much.
0
 
pony10usCommented:
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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now