1 / 9

= G2>F2

1. Write an Excel formula in cell 'Stock Info'!H2, which can be copied down to cell 'Stock Info'!H7, to determine (T/F) if a profit was made on  ATT stock. = G2>F2. 2. Write an Excel formula in cell Anaylsis!F1 to determine (T/F) if you made a profit on all the stocks listed.

Download Presentation

= G2>F2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. 1. Write an Excel formula in cell 'Stock Info'!H2, which can be copied down to cell 'Stock Info'!H7, to determine (T/F) if a profit was made on  ATT stock. =G2>F2

  2. 2. Write an Excel formula in cell Anaylsis!F1 to determine (T/F) if you made a profit on all the stocks listed. =AND('Stock Info'!H2:H7)

  3. 3. Write an Excel formula in cell Anaylsis!F2 to determine (T/F) if you lost more than $1,000 on any stock. =OR('Stock Info'!G2-'Stock Info'!F2<-1000, 'Stock Info'!G3-'Stock Info'!F3<-1000, 'Stock Info'!G4-'Stock Info'!F4<-1000, 'Stock Info'!G5-'Stock Info'!F5<-1000, 'Stock Info'!G6-'Stock Info'!F6<-1000, 'Stock Info'!G7-'Stock Info'!F7<-1000)

  4. 4. Write an Excel formula in cell Analysis!F3 to determine (T/F) if you did not make a profit on any drug company stocks (Merck, Pfizer). =AND(NOT('Stock Info'!H4),NOT('Stock Info'!H5))

  5. 5. Write an Excel formula in cell Analysis!F4 (T/F) to determine if you only made a profit on ATT. =AND('Stock Info'!H2, NOT(OR('Stock Info'!H3:H7)))

  6. 1. Write an Excel formula in cell 'Stock Info'!H2, which can be copied down to cell 'Stock Info'!H7, to determine if a profit was made on  ATT stock. If a profit was made, display "Profit", otherwise display, "Not Profit".  =IF(G2>F2,"Profit","No Profit")

  7. 2. Write an Excel formula in cell Anaylsis!F2 to determine if you lost more than $1,000 on any stock. If you did display, "Yes, I did" otherwise, display "No, I did not". =IF(OR('Stock Info'!G2-'Stock Info'!F2<-1000, 'Stock Info'!G3-'Stock Info'!F3<-1000, 'Stock Info'!G4-'Stock Info'!F4<-1000, 'Stock Info'!G5-'Stock Info'!F5<-1000), "Yes, I did","No I did not")

  8. 3. Write an Excel formula in cell Anaylsis!F1 to determine if you made a profit on all the stocks listed. If you made a profit, display, "Yes, I did" otherwise, display "No, I did not". =IF(AND('Stock Info'!H2="Profit", 'Stock Info'!H3="Profit", 'Stock Info'!H4="Profit", 'Stock Info'!H5="Profit"), "Yes, I did","No, I did not")

  9. 4. Write a formula in cell 'Analysis'!F6 to determine how much of your portfolio you should sell.  The formula should return a dollar value based on the following criteria: If the value of stocks that did not make a profit is less than $15,000 then you will sell all stocks that did not make a profit.If the value of stocks that did not make a profit is at least $15,000 but less than $20,000 you will sell half the value of the stocks that did not make a profit (ex: if the value that did not make a profit is $16,000 you will sell $8000 worth).If the value of stocks that did not make a profit is at least $20,000 you will sell 25% of the value of the stocks that did not make a profit. =IF(F5<15000,F5,IF(F5<20000,0.5*F5,0.25*F5))

More Related