Stock Forum

Discuss value investing stock ideas

 You must be logged in to post
Search Forums:


 






Wildcard Usage:
*    matches any number of characters
%    matches exactly one character

Home Questions EPV

EPV
Page:   1  
No Tags
UserPost

8:18 am
May 6, 2010


Jae Jun

Admin

posts 1333
4

updated the previous post.

7:22 am
May 6, 2010


dmop12

Member

posts 39
3

Thanks for the help!

7:04 am
May 6, 2010


Jae Jun

Admin

posts 1333
2

Post edited 8:18 am – May 6, 2010 by Jae Jun

Fixed another error. I was referring to the wrong cell.

 

I see, it seems like I forgot to link it up. On each cell in row 66, there should be an IF statement.

For Cell C66: =IF(ISNUMBER(C67),C67,Statements!H20)

Cell D66: =IF(ISNUMBER(D67),D67,Statements!I20)

Cell E66: =IF(ISNUMBER(E67),E67,Statements!J20)

Cell F66: =IF(ISNUMBER(F67),F67,Statements!K20)

Cell G66: =IF(ISNUMBER(G67),G67,Statements!L20)

Cell H66: =IF(ISNUMBER(H67),H67,EPVData!O18)

Cell I66: =IF(ISNUMBER(I67),I67,EPVData!P18)

Cell J66: =IF(ISNUMBER(J67),J67,EPVData!Q18)

Cell K66: =IF(ISNUMBER(K67),K67,EPVData!R18)

 

 

 

 

1:50 pm
May 4, 2010


dmop12

Member

posts 39
1

When I try to add back one time charges or deduct nonrecurring income on line 67 of the EPV analysis nothing happens. I'm assuming  the yellow cells need to  be linked to another cell? If so, what cell should it link to? I might have somehow deleted the appropriate cell, but I just wanted to make sure before I deleted my spreadsheets to reinstall new ones.

 

Thanks
No Tags
Page:   1  


About the Stock Valuation Software forum

Most Users Ever Online: 147

Currently Online:
17 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 693
Posts: 3674

Membership:

There are 868 Members
There have been 8 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 272
Graeme – 120
zehua – 96
valueinvestortoday – 75
nell – 67
krackerjack121 – 67

Recent New Members: kalidas, NathanB21, jademan10, romans122, vincentbston, mrpenguin

Administrators: Jae Jun (1333 Posts)

Moderators: Jae Jun (1333 Posts), VANYA (1 Post), djsun (0 Posts)